Recalculate Selection


Wed Sep 08 2021 06:04:53 GMT+0000 (UTC)

Saved by @cnewnham #vba

Public Sub RecalculateSelection()
' I work with a lot of really large workbooks and worksheets and one of my very favorite easy macros is this one. I generally always have to have manual calculations on and sometimes larger worksheets are still slow. This macro allows you to refresh only selected cells.

    If TypeName(Selection) = "Range" Then Selection.Calculate
End Sub