Need help to reduce file size

Originally Posted by iturnrocks

I still cant figure out how to write macros. If someone could help me out with this I would appreciate it.

Currently I have a worksheet that is 20mb.
This file contains what takes up most of the space. I repeat this line many times throughout the worksheet.
Attachment 7323

Once again it is a zero eliminating code.

If someone could reduce the number of formulas for me, I think I could figure out how to adapt it to repeat throughout the sheet.

Thank you

Just remove the 'If' and in Tools, Options, View untick 'Show Zero Values'

optionally, if you want this for only a specified range, then format the columns required to #

hth
---