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
|