Refreshing specific formulas in worksheet programmatically

Question

I have developed an Excel plugin. It exposes three user-defined formulas to the Excel application. All that works fine. Now I need to add a refresh button that when clicked will refresh only those formulas in the worksheet. So in the button's click handler, what code do I need to write?

Using Application.CalculateFull() I can refresh all the formulas in the worksheet. Is there a way to refresh only specific formulas in the worksheet and not the entire worksheet?

Answer 1

Range("A3:C5").Calculate 'calculate all the cells from A3 to C5

OR

Range("A3").Calculate  'only calculate cell A3