Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning range to array not working
Marston wrote:
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" Drop the .Select Alan Beban |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning range to array not working
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. Alan Beban wrote in message ... Marston wrote: 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" Drop the .Select Alan Beban |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formula Not Working with Range with Formulas | Excel Discussion (Misc queries) | |||
Assigning 10x1 array to 2nd collumn of 10x3 array | Excel Programming | |||
Assigning 10x1 array to 2nd collumn of 10x3 array | Excel Programming | |||
Assigning array to range inside Excel Object | Excel Programming | |||
Assigning Array Values | Excel Programming |