Yes, you did.

I should have read both replies <bg.

JLGWhiz wrote:

Yep, I already told him that clears everything in the previous posting.
This one was just to show him how without using select or activate.
"Dave Peterson" wrote:

Maybe...

Worksheets("Sheet1").Range("A1").ClearContents

..Clear will clear the formatting, too. .ClearContents will just empty the cell.

JLGWhiz wrote:

Including the sheet reference:

Worksheets("Sheet1").Range("A1").Clear

or if you use the Select and Activate method and have selected
the sheet and cell you want.

ActiveSheet.ActiveCell.Clear

"Steve" wrote:

Hiya all,

Newbie alert!!.

I would like to thank those who have helped me so far!! .. your all fab.


onto the question.



When I call a sheet i need it to reset a cell to empty each time its
called. How?


thx


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080107-0, 07/01/2008
Tested on: 08/01/2008 00:00:25
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com





--

Dave Peterson


--

Dave Peterson