Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - Newbie: Auto deleting cell value
I have a range of cells from A1:H1.
I have some VBA code for a macro, which, when conditions are met results in a '1' appearing in any one of the above range of cells. A the worksheet is very large and I don't usually look at the top row it's easy for me to miss these 1's. If I don't notice them and delet them, future macros won't work. What I would be really grateful for, is some generic code to add to th existing code so that the 1 is deleted as soon as the event i complete. In this way, I won't need to remember to delete the 1 eac time. Hope you can help -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - Newbie: Auto deleting cell value
the 1 is deleted as soon as the event is
range("a1:h1").clearcontents |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel VBA - Newbie: Auto deleting cell value
Mark - thanks a lot!
Can I just ask you what the code would be if I simply wanted to clea the contents of A1? TIA -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel auto deleting zero at start of cell - change? | Excel Discussion (Misc queries) | |||
excel newbie cell update | Excel Discussion (Misc queries) | |||
Excel 2002 auto deleting | Excel Discussion (Misc queries) | |||
Newbie VBA Question; Deleting minimum value row | Excel Programming | |||
Newbie question on deleting duplicate rows | Excel Programming |