EXCEL: Calculate a specific range of cells or current selection

Is it possible in Excel to calculate only a certain range of cells,

Even if it is just the range selected for example.

I have a workbook that has all sorts going on.

To make it more efficient I have calculations set to manual.

Then hit F9 whenever I need to refresh, however, this can still take some time to calculate, (well over 10 mins)

Is it possible for me to select Cells A1:B10, and some how just refresh the formulas in this range ?

2 Answers

I just wanted to illustrate a non-VBA alternative:

• All cell in A1:C6 have formula =RANDBETWEEN(1,10)
• Calculation set to manual

Select a range, say A1:B4 and press Ctrl+H, find and replace all = with =, confirm.

If you go VBA-route then @Akina has the correct answer for you. I just want to add to that, it may be usefull to create a custom tab on the ribbon to assign the macro to. For example:

Worksheets("SheetName").Range("A1:B10").Calculate 

Create a macro with this code line and set it to a knob and/or a hotkey.

Is it possible to change Range("A1:B10") to Range.Selection ?

Range have no Selection property, but it is of Range type itself. Use simple

Selection.Calculate

If you mean "selection in some range" then use Intersect() function to obtain the range within both specified range and selection.