Skip,
Nice one, that got rid of the error - it now creates a new workbook, but it doesn't paste the data and then save the new workbook the script just stalls at that point.
Any ideas ?
Thanks
Phat
Created the following script (from help and some helpful web sites).
But there is an error when trying to paste the data to a new workbook (have been messing around with it all day).
Any suggestions would be hugely appreciated.
Have highlighted in bold where I think the error is.
Many thanks...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.