[Solved] Round cells then auto fill VBA

[ad_1]

This should help you get started.
Range.Formula property on MSDN
Range.AutoFill method on MSDN

With Activesheet.Range("AR8")
    .Formula = "=ROUND(IF(AP8>(AN8*P8),AP8,AN8*P8),2)"
    .AutoFill Destination:=.Resize(100), Type:=xlFillDefault
End With

0

[ad_2]

solved Round cells then auto fill VBA