VBA code to delete rows if a specific value is not present

**lorac1969** · 08-06-2014, 11:32 AM

Hello,

I'm trying to write a macro to update a report including deleting all rows that do not contain a specific value of TP in column K. I've searched the web and found various suggestions none of which are working for me.

Below is one of the examples. Any ideas?

Please Login or Register  to view this content.

Moderator Note: Please read the forum rules and add code tags whenever you post code. Because you are new to the forum, I have added them for you today.

**AB33** · 08-06-2014, 12:43 PM

A simple filter will do the job-No need for VBA. If you want a code, just record your actions using record macro.

**lorac1969** · 08-06-2014, 04:11 PM

Hi AB33, actually VBA is needed because I'm writing a macro which another person will use on a report they will pull on a weekly basis.

**AB33** · 08-06-2014, 04:39 PM

Please attach a sample and will show you the VBA code and a record macro are almost the same.

VBA code to delete rows if a specific value is not present

LinkBack

Thread Tools

Rate This Thread

Display

VBA code to delete rows if a specific value is not present

Re: VBA code to delete rows if a specific value is not present

Re: VBA code to delete rows if a specific value is not present

Re: VBA code to delete rows if a specific value is not present

Thread Information

Users Browsing this Thread

Similar Threads

Delete Rows based on values present in another column

[SOLVED] Transpose Rows to Columns VBA Code and delete specific account numbers

[SOLVED] Looking for VBA code to delete rows if values in 3 specific columns are the same

Code to go to a specific column name on all active sheets and delete all rows conaining 0

Delete Rows based on values present in another column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions