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