Thread: Clear contents of worksheet before populating
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default Clear contents of worksheet before populating
Of course, the first line should be

ActiveSheet.Cells.ClearContents


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


"Chip Pearson" wrote in message
...
Tom,

Try

ActiveSheet.Cells.Clear
' or
ActiveSheet.Cells.Clear

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


"Tom" wrote in message
...
Hi everyone, I need a piece of code that will allow me to
clear the contents of an entire worksheet so I can
repopulate it with fresh information.

Any suggestions?

Thanks




Reply With QuoteReply With Quote