| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
countif constants in a Range
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
countif constants in a Range
See if rng.SpecialCells(xlConstants).Count returns your desired result.
Alan Beban ibeetb wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Constants in Excel | Excel Discussion (Misc queries) | |||
| Range Name Constants | Excel Discussion (Misc queries) | |||
| Constants In Formulae | Excel Discussion (Misc queries) | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| constants | Excel Discussion (Misc queries) | |||
Linear Mode
