IF statements in Macros

F

Farley Granger

In a Macro I want to put a blank in a cell if that cell contains the word
"All"
Can someone tell me how to do that?
Thanks
 
V

Vasant Nanavati

Sub AllOrNothing()
If Range("A1") = "All" Then Range("A1") = ""
End Sub
 
G

Gord Dibben

Farley

Sub All_Gone()
For Each cel In Selection
If cel.Value = "All" Then
cel.Value = ""
'or cel.ClearContents
End If
Next
End Sub

Gord Dibben Excel MVP
 

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

Macro to select and delete levels of a document 2
Cell data entering slow! 0
Clearing Fields in a Word Form 5
Hide columns based on row values 2
Excel - Wich Function should I use? 1
Multiple templates with common styles 2
Word VBA - Delete text from bulleted paragraphs 1
Macro to copy table of contents to a new doc 0

Top