Give this statement a try...

VisibleValues = Range("A14:A83").SpecialCells(xlCellTypeConstants) . _
SpecialCells(xlCellTypeVisible).Count

Note: This code assumes that the values are constants and not values from
formulas.

--
Rick (MVP - Excel)


"Randy" wrote in message
...
I am looking for a way to count the values rows that are visible. I have
rows
A14:A83 with values. Rows A39:A83 may be hidden at time. When these rows
are
hidden is there a way to count the values in rows A14:A38 only, even if
rows
A39:A83 still contain values?


--
Randy Street
Rancho Cucamonga, CA