2 points of correction:
1. I meant to say I want to count the cells that DO have visible data
2. This is for a defined name, so array formulas (I believe) will not work.
I'm just trying to do something like
=OFFSET($A$1:$A$9,0,0,SOMECOUNT($A$1:$A$9),1)
as a defined range to select the data in the range (yes the data will all be at the top, but sometime the blanks are ="" and sometimes they have no formula, and I want to account for both)
Thanks,
~GoldFish