ExcelBanter - clear the entire active worksheet

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

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

- - clear the entire active worksheet (https://www.excelbanter.com/excel-programming/422371-clear-entire-active-worksheet.html)

NA_AB[_2_]

clear the entire active worksheet

how to clear the entire active worksheet at once?! I need something like,
Range.ClearContents() which is for a particular range of cells on excel.

Gary''s Student

clear the entire active worksheet

Cells.Clear
--
Gary''s Student - gsnu200826

Mike H

clear the entire active worksheet

Try,

ActiveSheet.UsedRange.ClearContents

Mike

"NA_AB" wrote:

how to clear the entire active worksheet at once?! I need something like,
Range.ClearContents() which is for a particular range of cells on excel.

NA_AB[_2_]

clear the entire active worksheet

hey guys, thanks you both! :) the question was very trivial one, am a new bie
though. thanks again!

"Mike H" wrote:

Try,

ActiveSheet.UsedRange.ClearContents

Mike

"NA_AB" wrote:

how to clear the entire active worksheet at once?! I need something like,
Range.ClearContents() which is for a particular range of cells on excel.

All times are GMT +1. The time now is 10:33 PM.