Unknown column length
If there are no empty cells in your list this will report out the
exact sheet row number:
Dim nRow As Integer
Range("B7").Select
Selection.End(xlDown).Select
nRow = Selection.Row
MsgBox nRow
On Oct 29, 10:04 am, Jock wrote:
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
|