Thanks a lot. I appreciate all of your suggestions.

Stopher wrote:
' Then use this to loop through the sheets and copy from one to the
other
Don't worry about this statement I took the loop out after i worked
out what you wanted.

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