Macro: Running a formula/argument

**firehousetk** · 11-01-2011, 02:31 PM

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!

**davegugg** · 11-01-2011, 02:47 PM

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

**firehousetk** · 11-01-2011, 02:54 PM

I did, but got something a little different than your code. I think I've got the argument wrong, though. It's running, but giving me a FALSE when it should be giving me a TRUE. Thanks again.

**davegugg** · 11-01-2011, 02:58 PM

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?