Thank you so much......It worked perfectly.
Now all I need is for the format in'Sheet1' to also be copied i
subsequent worksheets.
What used to take me ages to do every month, I can now do immediately.
Thanks again.....Really appreciate it
--
minx200
-----------------------------------------------------------------------
minx2001's Profile:
http://www.excelforum.com/member.php...fo&userid=1516
View this thread:
http://www.excelforum.com/showthread.php?threadid=27176