ExcelBanter - Clear a range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Clear a range (https://www.excelbanter.com/excel-programming/435935-clear-range.html)

ordnance1

Clear a range

How would one clear the range B1:G7 on Sheet1 (which is not the active sheet)?

L. Howard Kittle

Clear a range

I think this will do that.

Sheets("Sheet1").Range("B1:G7").ClearContents

HTH
Regards,
Howard

"ordnance1" wrote in message
...
How would one clear the range B1:G7 on Sheet1 (which is not the active
sheet)?

OssieMac

Clear a range

Sheets("Sheet1").Range("B1:G7").ClearContents

'Other Clear options
'.ClearFormats 'Clears formats only
'.Clear 'Clears all

--
Regards,

OssieMac

"ordnance1" wrote:

How would one clear the range B1:G7 on Sheet1 (which is not the active sheet)?

All times are GMT +1. The time now is 03:50 PM.