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

Nick's picture

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