Sub FillCellsFromAbove
Turn of screen updating to improve performance
Application.ScreenUpdating = False
On Error Resume Next
With selection
ActiveCell.FormulaR1C1 = "=sumif(Base!$D$2:$D$598:Base!$A$2$A$598;$C7;Base!$H$2:$H$598;$A7;Base!$B$2:B$598;V$3)"
'coloque até a linha 536
Active.Sheet.Range ("J7:J536"
'Convert the formula to value
.Value = .Value
End with
Err.Clear Application.ScreenUpdating= true
End sub
Será que alguém consegue me ajudar?