Hi Howard,

Am Tue, 10 Dec 2013 12:36:36 -0800 (PST) schrieb Howard:

.End(xlUp)(2).Resize(columnsize:=76) = varOut

When you use columnsize:= does the : more or less Dim columnsize in place as a long?

columnsize (or rowsize) is a keyword. You don't need to dim it

And could you use it like this if you had some rows also?

.Resize(rowsize:=10,columnsize:=76) = varOut

If I have to resize both dimensions I don't use the keywords. Then I
write it as:
..Resize(10, 76) = varOut


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2