Delete a cell when found

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i need to know how to delete the contents of a cell when a column of dates
contains the text "Past Due" using some type of formula or visual basic.
 
Formulas can't delete cells.

And maybe you don't need VBA.

If the cell contains only the text: Past Due
Select that column
Edit|Replace
what: Past Due
with: (leave blank)
replace all

If the cell can contain other text besides that "Past Due" string:
Select that column
Edit|Replace
what: *Past Due* (the asterisks are wild card characters)
with: (leave blank)
replace all
 
Thanks dave. that works good. is there a macro or something i can make that
will do the same thing by pressing a button??
 
Record a macro when you do it manually and you'll have the code that you can
assign to the Forms toolbar button.
 
Great. Thanks for all your help.

Dave Peterson said:
Record a macro when you do it manually and you'll have the code that you can
assign to the Forms toolbar button.
Click to expand...
 
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

Deleting specific information 3
Delete rows takes forever 4
Excel Import Comments 3
macro which delets cell if the cell above has the same keyword 2
Cells with varying number of lines 1
Problems to delete blank/empty cells 5
Trim help 2
How to delete ALL cells containing the same data 1

Back
Top