X . x-axis on a PivotChart, 346 . x-axis title in a chart, 322 .xla file extension, 283 . XLA file type, 239, 242 . xlA1 constant, 180 . xlAbsrowRelColumn constant, 180 I came up with this simple way to take care of it, but it takes forever since the user selects entire rows and not a specific range. Is there a faster way to do this loop and clear those "empty-appearing" cells? Code: Dim c as Range Set c = Selection For Each c In Selection If Len (c) = 0 Then c.ClearContents Next c. In this ArticleTurn Off Automatic CalculationsTurn Automatic Calculations Back OnDisable Automatic Calculations Macro ExampleManual CalculationVBA Settings - Speed Up CodeVBA Coding Made Easy Whenever you update a cell value, Excel goes through a process to recalculate the workbook. When working directly within Excel you want this to happen 99.9% of the time (the exception being… "One man's constant is another man's variable." - Alan Perlis . This post provides a complete guide to using the VBA Dim statement. The first section provides a quick guide to using the Dim statement including examples and the format of the Dim statement. AFAIK, the only way to control the order of calculation of cells is to set manual calculation mode [1], then selectively calculate cells and ranges in a macro, e.g. Range ("A1").Calculate and Range ("A1:A100").Calculate. Caveat: If you use Range ("A1:A100").Calculate, you cannot be sure of the order of calculation within the range. Application.Calculation = xlCalculationManual 'Cycle through first row of selected cells By looking in the Visual Basic Editor's Object Library (shortcut F2) we can determine that xlSum's constant value is -4157 and xlCount's constant value is -4112. Let's assume that the xlSum is currently what the Pivot Fields are being summarized by. If Steps to Insert Multiple Rows in Excel using VBA. 1. Ensure that your excel work has a developer tab as follows. If not, activate it as follows: 2. After Looking for the developer tab and finding out that it does not exist by default please do the following. Press the "File" tab. This will open a window that has a pane containing a list of Application.Calculation = xlCalculationManual. If you need to recalculate spreadsheet values while the macro is running you can use any of the following commands. The first command recalculates the entire workbook. The second command only recalculates a specific sheet. Enumeration assigns a constant numerical value to a variable. VBA can The label xlCalculationManual represents the number -4135 in the Application.Calculation enumerator, and that's all we need to know (even that pops up with the courtesy of Intellisense …). We say that the Application.Calculation property is enumerated. Defining our own Enumerators Join Date 03-21-2004 Location Bakersfield, CA MS-Off Ver 2010, 2016, Office 365 Posts 33,492 It turns off the calculation (xlCalculationManual) It applies the original formula, (using the Cells method) It performs the FillRight (an Excel Constant) it performs the FillDown (an Excel Constant) It runs the calculation (an Excel Method) It closes the workbook without saving using ActiveWorkbook Calculation = xlCalculationManual at the beginning of your code and Application. Calculation = xlCalculationAutomatic before ending of your code. Note: Other way of stopping calculation in workbook is change calculation mode is xlCalculationManual. So that Excel does not calculate values in the workboo