OK, I have to be doing something completely stupid.
I have the following line:
Sheets(wsEffMth).Range("G" & mth + 11).Formula = "=IF(" & Range("D" & mth + 11) & "=0," & """" & "," & Range("D" & mth + 11) & "/" & Range("C" & mth + 11) & ")"
and I keep getting errors on it.
I have a feeling that it is somewhere in the "" s.
Any help would be greatly appreciated.
Thank you
Dave
I have the following line:
Sheets(wsEffMth).Range("G" & mth + 11).Formula = "=IF(" & Range("D" & mth + 11) & "=0," & """" & "," & Range("D" & mth + 11) & "/" & Range("C" & mth + 11) & ")"
and I keep getting errors on it.
I have a feeling that it is somewhere in the "" s.
Any help would be greatly appreciated.
Thank you
Dave