VBA macro to delete all empty rows and columns

Hello,

I'm in need of a macro that will delete all the empty lines and columns within the spreadsheet. I need all empty lines after (and including) line 17 and all empty columns after (and including) Column V. I want to be able to add this to an existing macro.

edit: Also, the deleting would have to be done before anything else withing the existing macro.

The manual way I would do this would be to select the first empty line after the data (Ctrl+Shift+arrow key down), right click the spreadsheet and click delete. Same process for the columns. Then I would run the macro below

Thank you

Here is the macro I'm currently working with, just need the above concept added to the beginning

Please Login or Register  to view this content.