How do I express the condition "if value is not empty" in the VBA language? Is it something like this?
"if value is not empty then..." Edit/Delete Message
Use Not IsEmpty().
Not IsEmpty()
For example:
Sub DoStuffIfNotEmpty() If Not IsEmpty(ActiveCell.Value) Then MsgBox "I'm not empty!" End If End Sub
2.1m questions
2.1m answers
60 comments
57.0k users