Countif of a range

  • Thread starter Thread starter ibeetb
  • Start date Start date
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
 
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
 
Back
Top