hi Tom,

no not active cell.
i have different worksheets and have to delete (clear) the complete contents
of
worksheets that are currently not active!
something like
Worksheets("TestSheet").Range.Cells.ClearContents
but this line doesn't work!


"Tom Ogilvy" wrote:

do you mean other than the activeCell
v = activecell.Value
cells.ClearContents
activeCell.Value = v

--
Regards,
Tom Ogilvy

"bandy2000" wrote in message
...
Hi
How can I clear all cells of a worksheet other than the active worksheet?

Thanks