Okay, after using Tom's code, it works (Thanks Tom) but I'm still
getting #N/A's in my totals. I checked and it is the last value to be
filled in as far as the macro goes, so I don't understand why its
coming up as #N/A. Does anyone know of a way around that?


--
DKY
------------------------------------------------------------------------
DKY's Profile: http://www.excelforum.com/member.php...o&userid=14515
View this thread: http://www.excelforum.com/showthread...hreadid=393837