Home

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

Frequent 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
'Calling' a function from within a Word document
PMHunt1955 in Word on
2 Replies
Edge Insider doesn't show notifications
ThatWeirdAndrew in Discussions on
10 Replies
Problem to start Teams in the browser
André Diekmann in Microsoft Teams on
9 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies