Countif of a range

I

ibeetb

I have a range of 20 cells in a range. These cells are mixed with constants,
blanks, and formulas. I want to do a countif of the cells in the range
which hold constants ONLY.
can someone please assist.....

Thank you
 
J

JMay

Sample...
Sub CountConstants()
Range("A1:D11").Select 'Your Range
Selection.SpecialCells(xlCellTypeConstants, 23).Select
MsgBox "Your Constants count is " & Selection.Count
Range("A1").Select
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple arguments 3
Copy addition formula of non-consecutive horizontal cells 2
Excel Countif Function - Calculating Between Two Sets of Values 3
Mapping integers to strings 6
COUNTIFS using multiple named ranges in the criteria 0
conditional formatting update issue 5
Count Number of Unique Cells That Don't Have Certain Characters 0
Pasting a cell into bookmarked table from excel vba 1

Top