Excel VBA equivalent of formula ""

pioneer2000 · 16 Jul 2012 at 16:51

Trying to construct an IF formula that is input to a cell via a macro... whenever I specify "" (as in IF A1="") it throws up an error.

So if I can't use "", what can I use to mean "blank"?

Paddyqwerty1 · 16 Jul 2012 at 17:46

Have you tried using an apostrophe?

spydermixx · 16 Jul 2012 at 19:13

edit - nvm reread your post, have I got this right: you want the macro to run and then populate a cell with the formula?

If so then, double quotes should do the trick:

e.g. Range("A1") = "=if(A2>0,"""")"

GravyMonster · 17 Jul 2012 at 08:33

Try using ISBLANK.

IF ISBLANK(A1) ...

BlackCoat2k10 · 17 Jul 2012 at 08:52

I created a simple macro the other day to add a specified amount to each cell that was not empty, or = "";

Heres a snippet of the Sub, it may or may not be useful.

Dim SelectedRange As Range
For Each SelectedRange In Selection

If (IsEmpty(SelectedRange) Or SelectedRange = "") Then
''do something for empty/blank cells
ElseIf IsNumeric(SelectedRange) Then
''Do calculations
SelectedRange = calculation result
End If
Next