Thanks Bob,

Seems to work alright for the first three sheets then runtime error
occurs on the copy of worksheet.

any ideas?


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