Home

Debugged at the "Range("$V" & r).Formula". Can you see the syntax error?

Greg Bonaparte
Contributor

Sub Enter_Formulas()

For r = 30 To 32
Range("$T" & r).Formula = "=($Y$17-$Y$18)"
Range("$S" & r).Formula = "=ROUNDDOWN(($Y$17-$Y$18)/$Q" & r & ",0)"
Range("$V" & r).Formula = "=(($U & r) * ($Q & r))"
Range("$U" & r).Formula = "=IF(($S" & r & " > 0)*($R" & r & " > 0.00001), ROUNDDOWN(($Y$17-$Y$18)/$Q" & r & ",0)," & Chr(34) & Chr(34) & ")"
Next r

End Sub

 

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies