View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim May Jim May is offline
external usenet poster
 
Posts: 430
Default 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,