Assigning range to array not working

M

Marston

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"
 
A

Alan Beban

Marston said:
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"
Click to expand...

Drop the .Select

Alan Beban
 
M

Marston

Thanks Alan -

and please disregard the next message too.....I think I'm back to where I was
yesterday - at least I'm able to write out my arrays now.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Writing Range to Array 3
Array Help 2
UDF not working for VLookup 6
Set Rng = Range("S2:S293") 6
Object range failed 1
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
How to address elements in variant array? 4
Convert list to UPPER, lower & Proper cases. 21

Top