XL Pro
Board Regular
- Joined
- Apr 17, 2002
- Messages
- 249
- Office Version
- 365
- Platform
- Windows
Just wanted to make people aware of this useful utility:
From Chip Pearson's Website
VBA CodeCleaner by Rob Bovey
As you do extensive editing to a VBA project, lots of "garbage" gets left in the file because VBA doesn't properly clean up after itself. Not only does this increase the file size, but it can lead to very strange behavior at run time. CodeCleaner exports all your VBA code to text files, removes the modules from your project, and then imports the code from the text files. This forces VBA to clean out all the garbage and start with a "clean" copy of the code. I very strongly recommend this add-in. Download from Rob Bovey's site. (Or download the version for Excel5/95.)