tkaram
03-15-2017, 12:54 PM
Hello,
first time posting here; i tried searching the forum but couldn't find a solution, so thank you for the help:
I am trying to define and create a name for a specific and fixed range of cells in each of my sheets:
example:
Range A1:AK150 of the sheet "Data" to be named "Data"
Range A1:AK150 of the sheet "Beta" to be named "Beta"
...
the same for all the sheets in my workbook.
now obviously i can do it manually by going to Formulas Name Manager, however my workbook has 250 sheets. and it would take me hours to do so, and im sure for one of you guys the code for that could take 5mns maybe:)
thank you again for the help
cheers
first time posting here; i tried searching the forum but couldn't find a solution, so thank you for the help:
I am trying to define and create a name for a specific and fixed range of cells in each of my sheets:
example:
Range A1:AK150 of the sheet "Data" to be named "Data"
Range A1:AK150 of the sheet "Beta" to be named "Beta"
...
the same for all the sheets in my workbook.
now obviously i can do it manually by going to Formulas Name Manager, however my workbook has 250 sheets. and it would take me hours to do so, and im sure for one of you guys the code for that could take 5mns maybe:)
thank you again for the help
cheers