Need macro to delete entire row based on column name.

**Revathi kannan** · 03-23-2016, 04:13 AM

Hi all,

Please help me..

Need a macro to delete the entire row if a column "Country " contains with the word "Apple".

**alansidman** · 03-23-2016, 04:28 AM

This vba assumes the column A is the column holding the values. Change up the code as necessary

Option Explicit

Please Login or Register  to view this content.

**Revathi kannan** · 03-24-2016, 02:11 AM

Thanks.. but I need to first search for the column name... becoz apple will come under the column country... the country coulmn may appear in A or D or X...this is my problem... I am not able write based on the column name..

**bakerman2** · 03-24-2016, 02:40 AM

Please Login or Register  to view this content.

**Alf** · 03-24-2016, 01:35 PM

Myself I prefer using autofilter in order to get rid of all rows in one go i.e.

Please Login or Register  to view this content.

Alf

Need macro to delete entire row based on column name.

LinkBack

Thread Tools

Rate This Thread

Display

Need macro to delete entire row based on column name.

Re: Need macro to delete entire row based on column name.

Re: Need macro to delete entire row based on column name.

Re: Need macro to delete entire row based on column name.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to Delete Entire Row Based on Formula in Given Column

How to efficiently delete entire rows based on duplicates in one column

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

Trying to create a macro to delete entire rows based on a helper column having an account#

Macro to delete entire row based on cell contents

macro to delete entire row based on TWO cell values

How do you delete entire column with Macro?

Bookmarks

Bookmarks

Posting Permissions