Thread: Macro: Running a formula/argument

I'd like to insert the following argument into a coded module, but I cannot figure out how to code it. Would someone please give me a hand?

=IF(OR($F38="36x48 POD size",$F38="30x40 POD size",$F38="42x56 Pod size",$F38="48x64 Pod size"),"XL Moab POD Substrate","")

The argument will be absolute in cell H38, or in $H38

All best and thanks so much for the help!

Did you try the macro recorder?

Sub Macro1()
'
' Macro1 Macro
'

'
    Cells(38, "H").FormulaR1C1 = _
        "=IF(OR(RC6=""36x48 POD size"",RC6=""30x40 POD size"",RC6=""42x56 Pod size"",RC6=""48x64 Pod size""),""XL Moab POD Substrate"","""")"

End Sub

The only thing I changed on my code was the target cell where the formula is going; I set it to cell H38 instead of the active cell. I copied your formula, so there is no reason it should not be working.

Maybe you could post an example of it not working?