creating a macro to delete a row in a spreadsheet if the cell contains specified text

**dtm8119** · 09-29-2009, 11:19 AM

Hello all -

I need some help making a macro for a 2003 version excel file. I have a column (AX) with some entries like the following

2051CG2A22A2AS1B4M5P2
2051TG4A2B21AS1B4M5D4
2088G2S22A1B4
3051S2CD2A2D11A1AM5

The macro needs to find the combination's like 2051 with S1, or 3051S with D11 within the cell. If it finds a combination like that, it should delete the entire row. If I have a macro like that, the only remaining entry from above would be 2088G2S22A1B4. Could somebody please help me out with this....it would be greatly appreciated!!!

Dan

**shg** · 09-29-2009, 11:25 AM

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title appropriately.

thanks.

**20 Ton Squirrel** · 09-29-2009, 11:40 AM

Here's a quick and dirty run through. Highlight the cells containing the values you're testing against and then run this:

Please Login or Register  to view this content.

Note that it clears the entire row. When looping through a Selection it gets kinda tricky when you delete a range contained within. Excel doesn't really take into account the Selection changes when you delete/add within it. You can code around that, of course, but I'm keeping it basic.

**dtm8119** · 09-29-2009, 11:52 AM

Thank you....I'll give that a try!

creating a macro to delete a row in a spreadsheet if the cell contains specified text

LinkBack

Thread Tools

Rate This Thread

Display

creating a macro to delete a row in a spreadsheet if the cell contains specified text

Re: making my first Macro!

Re: creating a macro to delete a row in a spreadsheet if the cell contains specified

Re: creating a macro to delete a row in a spreadsheet if the cell contains specified

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions