Add Condition To Macro

[erock24]

I have been using this macro:

Please Login or Register  to view this content.

To find the "Total" row and delete columns D:O that show a zero. Macro works great, but I would like to add a condition that makes the macro only delete the columns if the date in row 7 is greater than today (or the month is greater than the current month.
I supplied an example. Thanks for the help.

ps
This question was posted as a follow up at:
http://www.mrexcel.com/board2/viewto...988&highlight=

[bhofsetz]

Use an If statement before your delete statement

Please Login or Register  to view this content.

[erock24]

thank you very much for your reply.
The code however, has a compile error saying wrong number of arguments or invalid property assignment. It highlights the word "Format".

[bhofsetz]

Not sure why it isn't working for you it seems to be running fine for me.

Make sure you have copied it exaclty and aren't missing any parenthesis on that line.