Hi

When it's possible, then simply avoid such situations - it makes your life
much easier :-)

When you can't avoid gaps, use an hidden column with enough predefined
formulas, to create an always contignous column, and use this column to
calculate the number of rows in range. P.e. something like this for cell
A100
=IF(AND(OFFSET(A100;1;0)="",B100=""),"",ROW()-NumberOfHeaderRows)


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )



"Dantz" wrote in message
oups.com...
thanks lot...but what if my range down can have a gap?...there maybe a
cell that is empty within the range...