select contents of entire worksheet
Dave you can use a any of the following:
cells.clear
worksheets("Sheet1").cells.clear
Sheet1.cells.clear
Worksheets(1).cells.clear
Jeff
-----Original Message-----
I'm trying to clear the contents of an entire worksheet
from a macro but I can't find any way of doing this.
I don't want to delete the sheet only clear the contents.
I've gone round in circles with the range
(???).clearcontents
style as I can only see that defining the maximum number
of
possible cells (ie range("A1:IV65536").clearcontents)
will ensure
that the whole sheet is cleared.
Am I just missing something obvious ? or is this the way
to do it.
Dave
.
|