| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Array list writing to an Array of 'scattered cells' ?
Hi Howard,
Am Fri, 24 Mar 2017 01:56:27 -0700 (PDT) schrieb L. Howard: For n = LBound(vaSrc) To UBound(vaSrc) Range(vaTgt(n)) = Range(vaSrc(n)) Next 'n try: For n = LBound(vaSrc) To UBound(vaSrc) Sheets("Sheet4") .Range(vaTgt(n)) =Sheets("Sheet3"). Range(vaSrc(n)) Next 'n Regards Claus B. -- Windows10 Office 2016 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Array list writing to an Array of 'scattered cells' ?
On Friday, March 24, 2017 at 2:02:25 AM UTC-7, Claus Busch wrote:
Hi Howard, Am Fri, 24 Mar 2017 01:56:27 -0700 (PDT) schrieb L. Howard: For n = LBound(vaSrc) To UBound(vaSrc) Range(vaTgt(n)) = Range(vaSrc(n)) Next 'n try: For n = LBound(vaSrc) To UBound(vaSrc) Sheets("Sheet4") .Range(vaTgt(n)) =Sheets("Sheet3"). Range(vaSrc(n)) Next 'n Hi Claus, Works perfect... I can't believe I had it correct EXCEPT for Sheets(Sheet4).Range(vaTgt(n))... where I was not using " "'s. DUH Thanks, Howard |
| Reply |
| 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 | |||
Hybrid Mode
