Hi Folks!

Curious about using Index.......

When you index an entire column like A:A, are you really indexing an array
of 65536 values or are you just indexing the used range?

Biff

Whole column I believe.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Biff" wrote in message
...
Hi Folks!

Curious about using Index.......

When you index an entire column like A:A, are you really indexing an array
of 65536 values or are you just indexing the used range?

Biff

The reason I ask is that when I evaluate formulas with Index, the indexed
values are never shown.

Thank, Bob

Biff

"Bob Phillips" wrote in message
...
Whole column I believe.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Biff" wrote in message
...
Hi Folks!

Curious about using Index.......

When you index an entire column like A:A, are you really indexing an
array
of 65536 values or are you just indexing the used range?

Biff