vba formula

[VegasNath]

ws1b.Range("T" & row).Formula = "=MID(("C" & row), 10, 6)&"" - ""&J2"

Can anyone see what is wrong with my logic here? I have this inside a 'for next' loop but I am getting a syntax error.

[HansV]

There shouldn't be a " before C, and there should be a & " after the word row in the formula:

ws1b.Range("T" & Row).Formula = "=MID((C" & Row & "), 10, 6)&"" - ""&J2"

BTW, "row" is not a very good name for a variable, since it is also the name of a built-in property. I'd use lngRow instead.

[VegasNath]

Thanks Hans. The J2 also needs to be J & row. Why can I never work the syntax out with these?

Got there eventually.....

ws1b.Range("T" & row).Formula = "=MID((C" & row & "), 10, 6)&"" - ""&J" & row & ""

[HansV]

You can omit the & "" at the end, it doesn't do anything: appending "" to a string doesn't alter that string.