activesheet.cells.clearcontents

Will clear all the values and formulas from the activesheet.



kirkm wrote:

Looking for a method to delete everything in a Worksheet from code.
Not the sheet itself, though.

And, is it possible to keep the structure, i.e the way the columns
have been formatted ?

Many thanks - Kirk

--

Dave Peterson