Clear the content of a worksheet using VBA
 

I want to clear the content of a whole worksheet using VBA.
Does anyone know how to do it?

Thanks!

Clear the content of a worksheet using VBA
 

Hi Shawshank
Sheets("Sheet1").Cells.clearcontents

HTH
Regards
Pascal


"Shawshank" a écrit dans le message de
...
I want to clear the content of a whole worksheet using VBA.
Does anyone know how to do it?

Thanks!

Clear the content of a worksheet using VBA
 

Try something like

Worksheets("Sheet1").Cells.Clear ' or ClearContents


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Shawshank" wrote in message
...
I want to clear the content of a whole worksheet using VBA.
Does anyone know how to do it?

Thanks!

Clear the content of a worksheet using VBA
 

ActiveSheet.Cells.ClearContents

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Shawshank" wrote in message
...
I want to clear the content of a whole worksheet using VBA.
Does anyone know how to do it?

Thanks!