if you don't set the rngNHO to some range then it is empty...

Die_Another_Day

Celt wrote:
Thanks guys!

Quick question Ardus...

With your code, if rngNHO is nothing...will that cause an error?


--
Celt
------------------------------------------------------------------------
Celt's Profile: http://www.excelforum.com/member.php...o&userid=19413
View this thread: http://www.excelforum.com/showthread...hreadid=550393