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