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,
|