Click the cell just below the last number or amount in column B to select it.
#STRIKETHROUGH IN GOOGLE SHEETS CODE#
Launch Excel again, and open the workbook file which contains the VBA code you created earlier. Save the workbook file again, and then close Excel. Close the VBA editor window to return to the Excel spreadsheet file.
Public Function SumNoStrike(rngSumRange As Range) As Single Dim rngCell As Range For Each rngCell In rngSumRange If IsNumeric(rngCell.Value) Then If = False Then SumNoStrike = SumNoStrike + rngCell.Value End If End If Next rngCell End FunctionĬlick “File” and then “Save” on the VBA editor menu bar. Copy and paste the following code into the new module code window: Click “Insert” on the VBA editor menu bar, and then click “Module.” A new “Module1” link appears under the Modules folder in the Project-VBAProject pane of the editor window.ĭouble-click the “Module1” link. Press the “Alt-F11” keys to launch and display the Visual Basic for Applications editor window. Save the workbook after entering all of the required data. Strikethrough other amounts or numbers in column B that you want to exclude from the addition calculation. The number or amount in the field now has a strikethrough symbol through the middle of it. When the pop-up list appears, click “Format Cells.” Click the “Font” tab, and then click and enable the “Strikethrough” option. Right-click the first number or amount that you want to strikethrough, or exclude, when you add figures in column B. In the second, or B, column, enter numbers or amounts that correspond with the text or labels in column A. Create descriptive text or labels for numbers or amounts in the first column, or column A.
0 kommentar(er)
