Thanks Dave and Bob

Dave, I was getting an error at destcell, I put a on error resume next
command in, inserted a blank row on my data sheet as the program started at
row 2 (I did try to change that to row 1 but it outputted the data wrong)

Once again thanks for all your help

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200601/1