Using Index(A:A,.........)

B

Biff

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
 
B

Bob Phillips

Whole column I believe.

--

HTH

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

Biff

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

Thank, Bob

Biff
 
Top