I have a daily variance report I export to Excel and every day I have to delete certain rows and the certain columns before I can run a macros to delete all the zero value rows. I can not run this macros before the time as the the rows and columns that I delete contain zero values and thus I will lose most of my work if I run the Macros before hand.

The rows and columns are set, so the exact same rows and columns are deleted every day. So I need a macros to delete the set rows and then another macros to delete the columns. I'm not very good with programming so any help will help.


Thanks in advance...