instead of counta( etc use
match(9999999,$3:$3)-5
and check by touching the f5 key and typing in the name of the defined range
if text use "zzzzzzzzzz"
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Carrie_Loos via OfficeKB.com" <u34134@uwe wrote in message
news:802027b0c3f82@uwe...
Yes, I see, thanks - Is there any other solution to a dynamic range? Since
the range is picking up 3 extra columns can I put another offset -3
somewhere?


Don Guillett wrote:
COUNTA

See Also

Counts the number of cells that are not empty and
That wasn't helpful as I have already been to the help index.

[quoted text clipped - 5 lines]

1 1 1 1 1 1

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200802/1