Forum Discussion
macro command for function key F9
Hello I recorded a macro in Excel, one of the commands recorded in the macro was to calculate a formula (function key F9). When I opened the macro for editing, this was the line that appeared in th...
If you want to recalculate the active cell:
ActiveCell.Calculate
If you want to recalculate all cells in the current selection:
Selection.Calculate
If you want to recalculate the active worksheet:
ActiveSheet.Calculate
If you want to recalculate the workbook:
ActiveWorkbook.Calculate
If you want to recalculate all open workbooks:
Application.Calculate