If you insert a new row 1, you'll see a difference.

By (my opinion only) in cases like this, I don't see much difference at all.

And if you start in a cell that's not in row 1, you'll see a difference.

David Biddulph wrote:

"Dave Peterson" wrote in message
...

Peo Sjoblom wrote:

Another way, copy down this formula 255 rows

=CHAR(0&ROWS($A$1:A1))

Slightly shorter:

=CHAR(ROWS($A$1:A1))

<vbg

Is there any difference from the shorter still
=CHAR(ROW())
?
--
David Biddulph

--

Dave Peterson