ExcelBanter - Clear range of cells in different worksheet

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

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

- - Clear range of cells in different worksheet (https://www.excelbanter.com/excel-programming/319839-clear-range-cells-different-worksheet.html)

Tim Kelley

Clear range of cells in different worksheet

I need to clear a range of cells in a different worksheet than is the
activesheet. Is there a way to set what worksheet is the current sheet?

Thanks

Frank Kabel

Clear range of cells in different worksheet

Hi
try
worksheets("other_sheet_name").range("A1:B20").cle arcontents

--
Regards
Frank Kabel
Frankfurt, Germany

Tim Kelley wrote:
I need to clear a range of cells in a different worksheet than is the
activesheet. Is there a way to set what worksheet is the current
sheet?

Thanks

All times are GMT +1. The time now is 05:26 AM.