Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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" |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |