See my earlier reply.

HTH,
Bernie
MS Excel MVP


"Tre_cool" wrote in message
...

I don't understand where I'd put in MinAddress(Range("V:V"))? Do I keep
MinNum?

Thanks
Trevor


--
Tre_cool
------------------------------------------------------------------------
Tre_cool's Profile: http://www.excelforum.com/member.php...o&userid=26416
View this thread: http://www.excelforum.com/showthread...hreadid=475552