Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Seems like I alway have trouble when dealing with disjoint ranges.
This time I'm trying to do a simple copy of a matrix (2-D array) into a disjoint range. The dimensions of the disjoint range and the array are the same, but I get gobbledygook (without pattern) when I do the assignment. The first line actually copies fine, but then the other lines that are disjoint from the first, won't work. Dim matrix As Variant 'code to fill matrix Range("testrange") = matrix -- Lance Roberts Control Systems Engineer Golden Valley Electric Assoc. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order) | Excel Programming | |||
Last Row in Disjoint Range | Excel Programming | |||
Disjoint range for DSUM criteria | Excel Worksheet Functions | |||
Copying array formula to a range of cells... | Excel Programming | |||
Quick way of copying Range to (sub)Array ? | Excel Programming |