| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reset cell after change | Excel Programming | |||
| Set cell to record date when adjacent cell is filled AND NOT RESET | Excel Worksheet Functions | |||
| Way to reset the last cell to be EOF | Excel Discussion (Misc queries) | |||
| how do you reset your arrow keys to move cell to cell? | New Users to Excel | |||
| how to reset a value in a cell after another | Excel Programming | |||
![Steve[_94_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
