Feb 23 2019 11:37 AM
Can anyone see the problem with this?
Sub Enter_Formulas()
For r = 30 To 33
Range("$U" & r).Formula = "=SUM($Y$17-$Y$18)/($Q & r))"
Next r
End Sub
Not sure why I get run time error
Feb 24 2019 01:02 AM
Hi!
Try it with that:
Range("$U" & r).Formula = "=SUM($Y$17-$Y$18)/($Q” & r &”))"
Some letters are missing in your posted VBA Code, like one more & und one ". Should work now.
Hope that helps. Greets, Eva.