Getting Value of Array element in Immediate Window

[Jim May]

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,

 

[Bob Phillips]

It's 2D Jim and there is no Value property

?arr(2,1)


--

HTH

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

 

[Tom Ogilvy]

? arr(2,1).Value

an array produced this way is always one based and two dimensional.

In your case Arr(1 to 3, 1 to 1)

 

[Jim May]

Tks Bob
I should remember that in my reading
of all this

 

[Dave Peterson]

Put a watch on arr.

You'll see that it's array, but it's a 3x1 array (3 rows x 1 column).

So if you used:

?arr(2,1)

you'll see a result.

And your array isn't a range, so it doesn't have a .value property.

 

[Tom Ogilvy]

Sorry
? arr(2,1).Value

should be without the Value

? arr(2,1)