View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Howard Howard is offline
external usenet poster
 
Posts: 536
Default Open four Wbooks, copy four columns from each to Master Wbook

On Monday, December 2, 2013 3:31:29 AM UTC-8, Claus Busch wrote:
Hi Howard,



Am Mon, 2 Dec 2013 03:23:53 -0800 (PST) schrieb Howard:



.Resize(rowsize:=lCol1) = rangeA




you see that I declared rangeA as variant.

The code reads the values of the range in this array and therefore I

have to resize the output range for the count of rows (the count of

items into this array)





Regards

Claus B.


Okay, thanks. I'll need to make some notes to myself on that, plus some study time.

Howard