Search code examples
excelexcel-2007vba

Excel (2007) VBA - .Formula with quotes in it

I tried putting the following code into a program yesterday. VBA called an error. I assume it is because of the double quotes inside the formula. I googled and all results I found just gave the basic of putting formulas in, but none explained how to get around quotes inside.

(there was a With statement before this, Pivot is a worksheet name)

.Range("A2").Formula = "=IF(Pivot!A5="",A1,Pivot!A5)"

Any help is much appreciated. Thanks!

Solution

  • Whenever in doubt, record a macro if it allows :)

    Try this

    .Range("A2").Formula = "=IF(Pivot!A5="""",A1,Pivot!A5)"