For Each sheet in WkBook problem
Hi Howard,
Am Thu, 26 Nov 2015 20:55:57 -0800 (PST) schrieb L. Howard:
you have a parenthis on the wron place
.Cells(lNextRow, 1).Resize(UBound(vData), UBound(vData), 2) = vData
.Cells(lNextRow, 1).Resize(UBound(vData), UBound(vData, 2)) = vData
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|