VBA code to delete rows if empty cell in column A in a workbook

**naomip** · 11-08-2017, 08:15 AM

Hi,

I am quite new to Excel so not very good at this!

I need to write a VBA code that goes through every worksheet in a workbook, and deletes an entire row if it is blank.
This can be done based on an empty cell in column A.

I also need to combine every worksheet in the workbook onto one big spreadsheet

Thanks in advance!!

**TMS** · 11-08-2017, 08:41 AM

Record a macro ... AutoFilter column A to select blank cells, select the visible rows, except the header, and delete them (using the delete icon on the ribbon). Then clear the filter.

After that, it's just a case of looping through all the worksheets doing the same thing.

Try it and come back if you have problems.

VBA code to delete rows if empty cell in column A in a workbook

LinkBack

Thread Tools

Rate This Thread

Display

VBA code to delete rows if empty cell in column A in a workbook

Re: VBA code to delete rows if empty cell in column A in a workbook

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Delete all rows that have the word "good" in column H AND an empty cell in column K

Delete empty rows with VBA code

How to delete rows based on whether or not a cell in column B is empty or null

Delete Rows Based On Empty Cell in Column Works Perfectly For A, but Not J

Code Amendment - Delete Empty Rows

[SOLVED] still have empty cell after run Delete empty cells code

[SOLVED] delete empty rows in workbook

Bookmarks

Bookmarks

Posting Permissions