Solved

# Pasting in these complicated formulas (part II)

Posted on 2014-04-13

Hi All,

I asked how to paste in these formulas before in part I of the code and thought I had the answer:

(1) "= IIf(Evaluate(Worksheets(""Tickets"").Cells(r1, ""A"").Value * Worksheets(""Tickets"").Cells(r1, ""B"").Value) < Evaluate(Worksheets(""OtherSheets"").Cells(r1, ""D"")), 1, 0)"

(2)"a = IIf(Evaluate(Worksheets(""Tickets"").Cells(r1, ""A"").Value * Worksheets(""OtherSheet"").Range(""$d$1"").Value) < Evaluate(Worksheets(""thisSheet"").Range(""$e$1"")), 1, 0)"

...and this works except I get the "answer" of 1 or 0 right away.

The next step is to actually have these formulas pasted in so that they are evaluating.

In other words, after the operation is done I don't want to just to see a "1" or "0" in the cell. I would like to see the whole formula.

In other, other words, I would like it in this form:

"= if(constants!AO" & i & ">constants!AM" & i & ", 1, 0)"

I ordinarily can't even do the simplest of these kinds of "paste ins" so I have zero percent chance right now with these things.

thanks for your help!