O ordnance1 Nov 8, 2009 #1 How would one clear the range B1:G7 on Sheet1 (which is not the active sheet)?
L L. Howard Kittle Nov 8, 2009 #2 I think this will do that. Sheets("Sheet1").Range("B1:G7").ClearContents HTH Regards, Howard
O OssieMac Nov 9, 2009 #3 Sheets("Sheet1").Range("B1:G7").ClearContents 'Other Clear options '.ClearFormats 'Clears formats only '.Clear 'Clears all
Sheets("Sheet1").Range("B1:G7").ClearContents 'Other Clear options '.ClearFormats 'Clears formats only '.Clear 'Clears all
