I would like to use a VBA Macro to automatically delete blank row in an Excel table. I have seen examples on how to delete rows in an Excel spreadsheet, but not for an Excel table.
Does anyone have an example on how to automatically delete blank rows in an Excel table using a VBA macro? Thanks!
Hi Excel987,
The trick to the problem is to start at the last row and move up, checking if the row is blank (or the cell is blank in your column). Then when you use VBA to delete the EntireRow it will work. Many people try to start at the top and move down which doesn't work well when two blank rows are next to each other. If you supply a sample workbook, showing what you have, the VBA is easier for us to write...
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Why not try a sort to move the blank rows to the bottom of your table.
Hi MarvinP,
I was able to find the solution to deleting blank rows in an Excel table using a VBA Macro. Thanks you for responding to my post. Below is the code:
Please Login or Register to view this content.
Hi dangelor,
I was able to find the solution to deleting blank rows in an Excel table using a VBA Macro. Thanks you for responding to my post. Below is the code:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks