I've finally finished a complex (for me) workbook, and have it working the way it's supposed to. The only problem is slow start, save and close times, and I'm suspicious this is probably due to less than efficient code. (Most of my macros are recorded, with ssome editing help from the nice people in this forum.
Now I want to go back in and edit the macros to clean them up as much as possible. What's the best way to do this? Should I just put a ' at the beginning of the lines i'm not sure about, so Excel doesn't read it as code, and then try to run it to see what happens? Are therre code editors that will search for unnecessary items?
Any suggestions would be appreciated.
Thanks in advance.
Jerry
Bookmarks