| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Cells to variant array
Thanks, this works for me to.
"Bob Phillips" a écrit dans le message de news: ... This works for me Dim rgCurr As Range Dim vaRst Dim iRow As Long, iCol As Long iRow = 3: iCol = 6 Set rgCurr = Range("A1:H10") vaRst = rgCurr.Cells(2, 1).Resize(iRow - 1, iCol) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Jean-Pierre Bidon" wrote in message ... Hie, I think this question is rather banal but I'm stucked on it. I would like to copy a range (or a collection of cells) in a variant array. Using this syntax doesn't work: --- vaRst = rgCurr(Cells(2, 1), Cells(iRow, iCol)) Need help. Thanks. Jean-Pierre Bidon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ReDim Variant array for worksheet copy | Excel Programming | |||
| Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
| Array problem: Key words-Variant Array, single-element, type mismatch error | Excel Programming | |||
| Retrieve variant array of cells as formatted in the cell | Excel Programming | |||
| variant array containing cel adresses convert to actual ranges-array | Excel Programming | |||
Threaded Mode
