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
Last Row = Range ("A" & Rows.Count).End(xlUp).Row