below macro ...
... searches for the string 'Sales' and creates ranges for the respective 'Current Region'
I would like the macro to create ranges with a worksheet level scope (local), not a workbook-level scope (global).
How does the code have to be re-written?
Help is much appreciated. Thank you very much in advance.
I have attached a sample file with the code for your convenience.