Hi All, I have the following code which tests to see if the value in column J is a "Y":
For x = 7 To Counter
Range("E" & x).Formula = "=if($J$" & x & "=Y,$D$" & x & " * .025,0)"
Next x
I am not sure how to show the "Y" with quotes in the formula. Without the quotes it bombs. I tried using the single ticks 'Y' but this did not work either. Any help would be appreciated.
Regards,
Bill Mahoney
For x = 7 To Counter
Range("E" & x).Formula = "=if($J$" & x & "=Y,$D$" & x & " * .025,0)"
Next x
I am not sure how to show the "Y" with quotes in the formula. Without the quotes it bombs. I tried using the single ticks 'Y' but this did not work either. Any help would be appreciated.
Regards,
Bill Mahoney