is it possible to recalculate only a cell or a range in VBA
is it possible to recalculate only a cell or a range in VBA ? What I like to use for a sheet is the following, but how to do it on a cell only ? Or range ?
' ActiveSheet.EnableCalculation = False ' ActiveSheet.EnableCalculation = True
There is a calculate method you can call on ranges:
Try it out by putting =Now() in A1 and running Calculate and watch it update the seconds :) You can for a recalc of all the cells in a sheet by using:
See also: Microsoft MSDN, Excel Recalculation, 16 July 2012.