Hi again,
Thanks for the response. I'd love to post the workbook, but it goes against company policy...i'm going to post the code of something that works quite well but not EXACTLY what I need, and maybe you could understand. If not, I'll edit my workbook out and pm it to you.
The problem with this code is that 1) I get #name errors because on my original workbook I use formulas (and custom functions) 2) I don't know where to place the code to save to tab delimited format.
I think problem 1) can be solved by switching the ws.copy method to something that uses .pastespecial and 2) can be solved rather easily; however, my limited vba skills are struggling.
Bookmarks