Hello friends,
I have an xls file with data. I named ranges following that rule:
range A2:A1000 =nameA (where nameA is the content of cell A1)
range B2:B1000=nameB (where name B is the content of a cell B1)
In the futue the file can grow and user can add himself additional data in column C.
I would like to create a macros which will result in:
1. deletion of the current range names used in the sheet
2. creation of new range name based on the following rule: Range X2:X1000=name that refers to the content of cellX1. X could be any column that has a data. Lenght of data could less or longer that 1000 rows.
Thanks in advance!!!
Bookmarks