Nested Formula Using VBA

I am filling a column with a formula, but I keep getting a compile error: "Expected: )" in the 2nd line of the code at ", "

Does anyone see what I am doing wrong?

Please Login or Register  to view this content.

Thanks for taking a look.

I converted your code to...

Please Login or Register  to view this content.

This gives the formula =OR(I2="",AND(F2>I2, F2>J2)) in cell A1

Is this what you were after?

I should have mentioned, the "i" and "v" are variables.

I just need it to fill the last column (i9) with the following formula for each row:

OR(v9="", AND(V6 > v9, v6 > v10))

Try this...

Please Login or Register  to view this content.

Personally, if I'm trying to build a string which includes quotes I always use Chr(34), rather than try to get the double quotes right - it ends up being easier to work with and looks a lot less confusing.

Norie, your first post worked fine. I just didnt see it until after I had replied with a sample. Thank you all.