Getting Value of Array element in Immediate Window
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,
|