Hi,
I am converting a list of about 100 static named ranges to dynamic named ranges.
Within my workbook of data sheets I have a spreadsheet with the range names in one column and the new dynamic ranges in another.
The ranges are in this format: "$A$A:INDEX($A$A,COUNTA($A$A)".
I would like to use VBA to go through the names list and convert each static range to its dynamic range.
In the workbook there are thousands of formulas that refer to the static named ranges.
Apparently I know just enough VBA to spend a bunch of time getting nowhere.
Can anyone help? Thank you!
I am converting a list of about 100 static named ranges to dynamic named ranges.
Within my workbook of data sheets I have a spreadsheet with the range names in one column and the new dynamic ranges in another.
The ranges are in this format: "$A$A:INDEX($A$A,COUNTA($A$A)".
I would like to use VBA to go through the names list and convert each static range to its dynamic range.
In the workbook there are thousands of formulas that refer to the static named ranges.
Apparently I know just enough VBA to spend a bunch of time getting nowhere.
Can anyone help? Thank you!