Excel VBA - Newbie: Auto deleting cell value

  • Thread starter Thread starter zoso69
  • Start date Start date
Z

zoso69

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
 
the 1 is deleted as soon as the event is

range("a1:h1").clearcontents
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Run Macro If Cell have "x" value 0
Excel VBA 1
Deleting specific information 3
Delete rows based on contents of Col A 0
Excel VBA help: Text file formatting 19
Macro that will insert a simple text string in top cell of text file 1
Reduce Numbers Down To A Specific Value 1

Back
Top