Sorry should know that myself (just change 'data' to 'sheet' in th
code!!) For some reason it is copying the code over and leaving row on
blank how can i change this from happening?

--
Message posted from http://www.ExcelForum.com