Adding and deleting empty sheets increases file size.
I saw some code on one of these sites, and unfortunately I don't know where and who's code it is so I cant thank him/her, and I wanted to compare it to some other methods of deleting sheets.
Following is the Function and macro I am talking about.
The timers were added by me to give me an idea for comparing purposes.
When I rune these macros several times, the file size goes from an original of 24 KB (See attached) to 600+ KB
Nothing is added to the 3 sheets but I checked that just in case.
What is the culprit that increases the file size?
All these codes are in the attached workbook
I use the following code to add sheets.
The following three macros also are used to delete back to 3 sheets.
Bookmarks