In my Excel file, i have about 50 named ranges. For example
A1:A35 is named as ALPHA
B1:B35 is named as BETA and so on.
Now all of these end at Row 35 but say in future I get a bigger data set and I want to increase the array of all these 50 named ranges to say:
A1:A100 to be Named as ALPHA
B1:B100 to be Named as BETA
Is there a way that can be done using VBA or any other suggestion?
Thanks