|
reset a cell
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 |
reset a cell
If you want it really empty:
ActiveCell.Clear If you only want the visible data gone and leave format and formulas then ActiveCell.ClearContents. "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 |
reset a cell
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 |
reset a cell
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 |
reset a cell
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 |
reset a cell
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 |
| All times are GMT +1. The time now is 05:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com