| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array list writing to an Array of 'scattered cells' ?
Try...
Sub Copy_ScatteredCells() Const sSrc$ = "F1,F2,F3,F4,F5": Const sTgt$ = "A1,D5,H9,J6,M11" Dim n&, vaSrc, vaTgt vaSrc = Split(sSrc, ","): vaTgt = Split(sTgt, ",") For n = LBound(vaSrc) To UBound(vaSrc) Range(vaTgt(n)) = Range(vaSrc(n)) Next 'n End Sub -- Garry Excellent, works great! Thanks Garry. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scattered array cells copy to scattered array cells another workbook | Excel Programming | |||
| Reading variable list of cells into array | Excel Programming | |||
| 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 | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
| Writing Range to Array | Excel Programming | |||
Threaded Mode
