Thanks Col

the spelling is correct, and it works fine presently, so i'm not sure
what's happening your end, I'm a newbie to VBA, maybe my workbook
structure is not set up correctly, would it be more helpful if I
attached the workbook


--
apndas
------------------------------------------------------------------------
apndas's Profile: http://www.excelforum.com/member.php...o&userid=36137
View this thread: http://www.excelforum.com/showthread...hreadid=559116