XL: How to Count Cells That Contain Formulas, Text, or Numbers
If you have limited programming experience, you may want to contact a Microsoft Certified Partner or Microsoft Advisory Services. For more information, visit these Microsoft Web sites:
Microsoft Certified Partners - https://partner.microsoft.com/global/30000104
Microsoft Advisory Services - http://support.microsoft.com/gp/advisoryservice
For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site:http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS
Selecting the CellsTo select formulas, text, or numbers, follow these steps:
- On the Edit menu, click Go To, and then click the Special button.
- In the Go To Special dialog box, to select all formulas, click Formulas and then click to select the Numbers, Text, Logicals, and Errors check boxes. To select text, select the Constants option and then click to select only the Text check box. To select numbers, select the Constants option and click to select only the Numbers check box.
Using VBA Code to Count the Selected CellsTo count the number of cells in the selection anddisplay the result in a message box, use the following procedure:
Sub Count_Selection() Dim cell As Object Dim count As Integer count = 0 For Each cell In Selection count = count + 1 Next cell MsgBox count & " item(s) selected"End Sub
Article ID: 213507 - Last Review: 12/05/2015 12:13:38 - Revision: 2.6
- kbnosurvey kbarchive kbdtacode kbhowto kbprogramming KB213507