Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
It's 2D Jim and there is no Value property
?arr(2,1) -- HTH RP (remove nothere from the email address if mailing direct) "Jim May" wrote in message news:YWKFe.1163$MZ6.59@lakeread01... If I have the following code: (Only first three lines shown) Sub namesheets() Dim arr As Variant arr = Range("A1:A3").Value and I STEP -THROUGH IT (using F8 key) after completing Line 3 I wish to go to my immediate Window and view say ? arr(2).value <<< but this of course is not working Get R/T 9 - subscript out of range.. what should I enter instead? TIA, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Set array element to empty | Excel Programming | |||
Further Array Element question | Excel Programming | |||
Array Element question | Excel Programming | |||
Array element | Excel Programming | |||
deleting array element | Excel Programming |