How do I delete several columns if the sum of the column is 0
Note I want to via VBA ananlyze each column in a worksheet and if the sum is 0 then delete the column. Note I can not use a static helper row to sum the column as the number of my rows will potentially change each time I run the spreadsheet...
In the attached I would need to have the macro delete Column "I"
I know I need to figure out the last row which I did...but from here I am a little unsure on how to proceed