thanks a lot guys
i used the 2nd solution as i couldnt get the first one to work
--
newToExcel
------------------------------------------------------------------------
newToExcel's Profile:
http://www.excelforum.com/member.php...o&userid=27192
View this thread:
http://www.excelforum.com/showthread...hreadid=484569