Clear a "moving" range offset from Target
Hi Howard,
Am Thu, 22 Jan 2015 04:39:26 -0800 (PST) schrieb L. Howard:
' Target.Offset(, 1).Resize(tRowCount, tColumn).Select '.ClearContents
try:
Target.Offset(, 1).Resize(tRowCount - 1, 1).ClearContents
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|