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