Have to delete entire column if specific work exist in row

**rizva9** · 07-27-2015, 09:33 AM

I'm using:

With Range("F:F")
.Replace " ", ""
.SpecialCells(xlCellTypeBlanks).EntireRow.delete

End With

but it also delete cell in which nothing is written.

**Parth007** · 07-27-2015, 10:21 AM

Please use Code Tags & write your code in it ... click # for it

Please Login or Register  to view this content.

**rizva9** · 07-27-2015, 12:06 PM

Please Login or Register  to view this content.

Have to delete entire column if specific work exist in row

LinkBack

Thread Tools

Rate This Thread

Display

Have to delete entire column if specific work exist in row

Re: Have to delete entire column if specific work exist in row

Re: Have to delete entire column if specific work exist in row

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need to find if duplicate values exist in a column, concatenate cells and then delete

[SOLVED] Macro to remove entire row if null value exist in column C

[SOLVED] Marco to delete entire row based on value in specific column

VBA to delete row if specific value exist in row above

Delete entire row from A to F if cell A has specific content

Delete entire row macro won't work

delete Entire Row if specified word exist

Delete row if value(array) doesnt exist in column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions