I have an excel app with a lot of vba and a lot of formulas. It has always
been around 10MB but after adding much more vba functionality (UserForms and
code mostly) it has grown by about 5MB. Many of the worksheets go past row
5000, even when I select all cells below row 200 for all columns and delete
(shift up & left). How can I reduce the file size? What components make up
file size other than data? Is there a way to evaluate these components?

Thanks