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/435936-clear-range.html)

ordnance1

Clear a range

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

arjen van der wal

Clear a range

Sheet1.Range("B1:G6").ClearContents

or

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

All times are GMT +1. The time now is 09:23 PM.