reset a cell

[Steve]

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

 

[JLGWhiz]

If you want it really empty:
ActiveCell.Clear

If you only want the visible data gone and leave format and formulas then
ActiveCell.ClearContents.

 

[JLGWhiz]

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

 

[Dave Peterson]

Maybe...

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

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

 

[JLGWhiz]

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]

Yes, you did.

I should have read both replies <bg>.