Wonderful! Thanks!

Lila
"Tom Ogilvy" wrote in message
...
This is a bit simpler:

=MID(ADDRESS(1,ROW(),4,TRUE,""),2,1+(ROW()26))

if you don't start in A1, change

Row()

to something like Row()-4. This would be if the formula starts in A5 as
an
example.

--
Regards,
Tom Ogilvy