Calculate only one row in a Worksheet
Hi,
I'm creating a new Workbook, but it has lots of sheets all of them as calculations, so when we implemented the following code:
Private Sub Button_Calculate_click()
Application.ScreenUpdating = False
Application.CalculateFullRebuild
Application.ScreenUpdating = True
End Sub
And the excel is updating all the cells, however I just want to update the
row in which I did the change. I can identify the row, but I don't know if
there is some way of only calculating the selected row. Can you please help
me?
Thanks in advance.
Best Regards,
Carvalhais
if you know the row.. say row
if you know the row.. say row 10
Rows(10).calculate
Thanks
It works perfectly.
Best Regards,
Carvalhais