View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marston Marston is offline
external usenet poster
 
Posts: 43
Default Assigning range to array not working

Can someone explain why this isn't working?

Sub Test()
Dim aArray as Variant

Set rng = Range("A1").CurrentRegion.Select
aArray = rng.Value

End Sub

When I break the code I see the following when I highlight
aArray

(on the Set rng, I put arrow of rng and I see: rng = nothing)
(on the rng.Value, I see <Object variable or With block variable not set

I have values in a 51000 x 10 range beginning at "A1"