Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
Im trying to write the first two rows and the last row of a range to a two-dimensional array Can this be done w/o looping? Thanks! Dim FlashArr() Set wkb = ActiveWorkbook Set rng = Range(D4) CellsAcross = Range(rng, rng.End(xlToRight)).Columns.Count ReDim FlashArr(1 To 3, 1 To CellsAcross) FlashArr = rng.Resize(2, CellsAcross) FlashArr = Range(rng.End(xlDown), rng.End(xlDown).End(xlToRight)) -- ______ Regards, Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with filling in an array formula | Excel Discussion (Misc queries) | |||
Filling an array from one sheet to another | Excel Programming | |||
Filling an array with a Loop | Excel Programming | |||
filling a form with an array | Excel Programming | |||
Filling an array with data | Excel Worksheet Functions |