"Harlan Grove" wrote in message
...
"T. Valko" wrote...
"Harlan Grove" wrote in message
...
=ROW(INDEX($1:$65536,1,1):INDEX($1:$65536,256,1 ))

Why index such a large range when the effective range is only 1:256?
...

Because $1:$65536 is the only range reference that's completely unaffected
by inserting or deleting rows/columns.
....

I was thinking that might be your reason.

Does it index the entire range or just the used range? My gut tells me
it's the used range but I'd like to know for certain.
...

The entire range.
....
Ok. Thanks, Harlan.

--
Biff
Microsoft Excel MVP