It shouldn't be too difficult to eliminate #N/A within your ranges, what
formulas are you using that return #N/A?


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=511535