Hello,
I am currently working on spread sheets that contain hundreds of items, each requiring a range name.
Is there a way of using VBA to automate creating a range name for each item?
I have a row with 100 items called fc_1, fc_2,... etc.
Thank you in advance for your help.
Ian
I am currently working on spread sheets that contain hundreds of items, each requiring a range name.
Is there a way of using VBA to automate creating a range name for each item?
I have a row with 100 items called fc_1, fc_2,... etc.
Thank you in advance for your help.
Ian