Changing column name in named ranges

[goels]

Hi All,

I have some code to create multiple named ranges as below:

Please Login or Register  to view this content.

This code is though incomplete. What I want to happen is that as i loops from 1 to 2 all instances of $B:$B should change to $C:$C, as it moves to 3 all instances of $B:$B should change to $D:$D. So like below:

When i = 2 the named range 12month_2 should be

Please Login or Register  to view this content.

When i = 3 the named range 12month_3 should be

Please Login or Register  to view this content.

Any ideas how this can be done?

Thanks

[Bob Phillips]

Try

Please Login or Register  to view this content.

[goels]

Thank you very much Bob - worked like a charm!