Hi!

I have a macro that pastes a set of formula in a spreasheet and I'm
receiving an "End of Statement" error when the macro runs. The code looks
like this:

Range("B2").Select
ActiveCell.FormulaR1C1 = _

"=IF(("A2")<("A3"),""000"",IF((MID(E2,3,1))=""S"" ,(MID(E2,5,3)),""000""))"

Where I'm trying to compare cell A2 < A3, etc., etc. Why doesn't it like
this???