VBA - Optimize File Size by Clearing Unused Area

By |Saturday, February 01st, 2020|Categories: VBA|Tags: , , , , , , , |0 Comments

Sometimes, you find that your file size is very huge even though data contained in not much. The reason for this is that there are unused formatting beyond your data range. Either you can clear off your rows and columns beyond data range but if this is frequent, you can use a macro to do this. You can perform following manual steps to do this without a macro. (more…)