Macro, If cell A has data but cell B is empty delete complete row

**stangz71** · 07-28-2011, 04:07 PM

I am looking for a macro that will delete the entire row if the "B" cell is empty, thanks in advance.

Cell A Cell B
server1 "C:\Windows
server1 (delete this row)

**BigBas** · 07-28-2011, 04:15 PM

Try something like this and report back:

Please Login or Register  to view this content.

**stangz71** · 07-28-2011, 04:26 PM

It works great but would it be possible to shift the cells up so that it only leaves one row between the next row with data?

**BigBas** · 07-28-2011, 04:33 PM

As it stands, it shouldn't leave any empty rows. Do you want it to leave any empty row? Would it be better to just clear the contents out of the entire row instead of actually deleting the row?

**stangz71** · 07-28-2011, 04:43 PM

For some reason it is leaving empty rows and just deleting the data from the cells. Ultimately, it would be nice to have something like the example below, one row between each cell with data. If this is too much, no worries, I appreciate the help you have given me so far.

server1 C:\Windows
(empty row)
server2 E:\TI\
(empty row)
server3 C:\Word_Documents
(empty row)
server4 E:\Backup

**BigBas** · 07-28-2011, 04:53 PM

Could you possibly post a sample of your workbook (use dummy data if necessary; also, I don't have Excel 2007, so xls format is needed)?

I'd have no problems adding empty rows between your data, although I generally advise against doing so. Empty rows can make analysis more complicated. If you still do need blank rows, I modify the code once I've seen your workbook.

**stangz71** · 07-28-2011, 05:12 PM

BigBas

I just tested this on a different spreadsheet and realized that it does exactly what I need. The spacing is even across the cells and that is what I needed. Not sure why the spacing wasn't even on the first spreadsheet but it works fine now. Thanks again for your help.

**BigBas** · 07-28-2011, 05:13 PM

Not a problem stangz. Let us know if anything needs to be changed in the future.

**stangz71** · 07-28-2011, 05:26 PM

Definitely, thanks.

**stangz71** · 07-28-2011, 05:34 PM

BigBas

Could you assist me with an outstanding request on the forum. If this is not possible, please let me know, thanks.

http://www.excelforum.com/excel-prog...omparison.html