how do you number Rows A-Z then AA-ZZ
 

I need to list the rows with A, B, C, at the start and then continuing with
AA, BB, CC - any suggestions please - fill down doesn't work!

how do you number Rows A-Z then AA-ZZ
 

In A1 enter:

=LEFT(ADDRESS(COLUMN(),ROW(),4),LEN(ADDRESS(COLUMN (),ROW(),4))-1)

and copy down
--
Gary''s Student - gsnu200790


"Rebecca Potter" wrote:

I need to list the rows with A, B, C, at the start and then continuing with
AA, BB, CC - any suggestions please - fill down doesn't work!

how do you number Rows A-Z then AA-ZZ
 

Brilliant - what a star - many thanks for that.
Regards, Rebecca

"Gary''s Student" wrote:

In A1 enter:

=LEFT(ADDRESS(COLUMN(),ROW(),4),LEN(ADDRESS(COLUMN (),ROW(),4))-1)

and copy down
--
Gary''s Student - gsnu200790


"Rebecca Potter" wrote:

I need to list the rows with A, B, C, at the start and then continuing with
AA, BB, CC - any suggestions please - fill down doesn't work!

how do you number Rows A-Z then AA-ZZ
 

This works for Excel 2007. For previous versions of Excel, the equation
fails after IV.

If you are using an older verison of Excel, try this macro:

Sub alphas()
alph = "A,B,C,D,E,F,G,H,I,J,K,L,M,N,O,P,Q,R,S,T,U,V,W,X,Y ,Z"
v = Split(alph, ",")
icl = 1

For i = 0 To 25
Cells(i + 1, icl).Value = v(i)
Next

irw = 27
For i = 0 To 25
For j = 0 To 25
Cells(irw, icl).Value = v(i) & v(j)
irw = irw + 1
Next
Next

End Sub

--
Gary''s Student - gsnu200790


"Rebecca Potter" wrote:

Brilliant - what a star - many thanks for that.
Regards, Rebecca

"Gary''s Student" wrote:

In A1 enter:

=LEFT(ADDRESS(COLUMN(),ROW(),4),LEN(ADDRESS(COLUMN (),ROW(),4))-1)

and copy down
--
Gary''s Student - gsnu200790


"Rebecca Potter" wrote:

I need to list the rows with A, B, C, at the start and then continuing with
AA, BB, CC - any suggestions please - fill down doesn't work!