Use a dynamic range. See this:

http://contextures.com/xlNames01.html#Dynamic

--
Biff
Microsoft Excel MVP


"Dave" wrote in message
...
COUNTBLANK function works Ok for cells A1:A10, but what if the number of
cells grow to A1:A100 or beyond? How can I make the fofmula adjust
automaticlly?