My Macro worked fine, then one day it started locking up excel right before the end of the sub. I have to End task out. The macro saves the file with a new filename at the beginning. If I open that file and try to rerun the macro after the lock up, it works all the way through. I'm thinking it's a memory overflow thing or something with the new file not existing. I don't know.
The code is below. The macros reside in a seperate workbook than the book being modified, the macros are initiated through the menu bar.
Thanks for looking, Ryan
==========================================================
Bookmarks