For...Next loop - trying to have named range increase by count of 1

[seaveegee]

Hi Everyone,
THanks for reading my question!

I have several steps I need to do with some data and it needs to be done 9 times.
I want to use For i= 1 to 9 to help speed up my writing but I am doing something wrong.

I have 8 named ranges that I need to create each of these 9 times:
Account1
Account2
Account3
...
Account9

I tried coding it:
Dim i as integer
For i = 1 to 9
activecell.name = "account(i)"
next i
but I get an error.

Anyone know if I can use the For Next to increase named ranges by a count of 1 on each "loop"?

Many thanks.
Christina

[mike7952]

maybe this

Please Login or Register  to view this content.

[seaveegee]

Thank you so much Mike!!!