wibbers2000
05-23-2009, 03:22 PM
I have a problem that I need help on.
I have attached a sheet but basically what I want to create dynamic name ranges.
column A is what I need to loop through and created a name from the cell value in column A
example; column A - A1 to A16 should be named ANTIC
column A - A17 to A27 should be named APPC
Column A - A28 to A51 should be named CaseC
etc etc
Any help is greatly received.
Regards
Paul
I have attached a sheet but basically what I want to create dynamic name ranges.
column A is what I need to loop through and created a name from the cell value in column A
example; column A - A1 to A16 should be named ANTIC
column A - A17 to A27 should be named APPC
Column A - A28 to A51 should be named CaseC
etc etc
Any help is greatly received.
Regards
Paul