countif constants in 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 (via code) of the cells in the
range which hold constants ONLY. I though the haveformula property would
work, but this property seems to be absolute....counting all or none based
on if there is an instance of a formula in any of the cells in this range

can someone please assist.....

Thank you
 
Back
Top