one option is to use a dynamic range. check debra's site
http://www.contextures.com/xlNames01.html
--
Gary
"Jock" wrote in message
...
How can I change this:
=COUNTIF($B$7:$B$2000,Z8)
to something which will 'detect' the max row numberin column 'B'?
2000 is an arbitrary figure and will fluctuate either way so I was looking
for a 'catch all'
Thanks,
Traa Dy Liooar
Jock