Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Index(A:A,.........)
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Index(A:A,.........)
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using Index(A:A,.........)
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|