numbering

[Steven Hook]

Hi,
I need to add a column to a workbook that runs as follows A1 - A200,
B1-B200,..., Z1-Z200, AA1-AA200, all the way to 1000000 rows, I'm doing them
by hand now, but I'm sure a formula could save a LOT of mouse work.
Thanks
Steven

 

[Bernie Deitrick]

Steven,

In row 1 of your column, enter the formula

=ADDRESS(MOD(ROW()-1,200)+1,INT((ROW()-1)/200)+1,4)

and copy down as far as you want thorugh row 51,200, where it will fall
apart. (You're not going to get to 1,000,000 rows anyway, since Excel only
has 65,536 rows.)

HTH,
Bernie
MS Excel MVP