countif constants in 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 (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
 
A

Alan Beban

See if rng.SpecialCells(xlConstants).Count returns your desired result.

Alan Beban
 

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

Finding last constant in range 1
Using <= in countifs statement 1
Stuck with multi worksheet Function 8
Take active cell value in for loop and offset based on another cellvalue for columns to offset 0
VBA - Insert row, copy contents of original row except for contents of column A 3
loop help 6
Sum If - Using the value of a parameter or constant in a formula tochange a condition 1
Mapping integers to strings 6

Top