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