Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Value of Array element in Immediate Window
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 | |
|
|
Similar Threads | ||||
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 |