Delete entire row if the cell does not contain a set of different numbers (please help)

[blackragon]

Hi guys,

I have a bunch of SCR files used for AutoCAD which I modify with Excel, please refer to the picture below:

Script Excel.png

The script has been trimmed for easier viewing, I'm trying to keep the rows which has the numbers shown in red ( .6. / .3. / .2. ),

I know this can be done manually by search all > select all rows that are needed > copy and paste, but I have a large number of scripts to handle everyday so I would like to do this with VBA.

My script below will only let me keep ( .6. ), how could this be modified so that it will keep all rows containing all 3 numbers at the same time ?

-------------------------------------------------------------------------------------------------------------------

Please Login or Register  to view this content.

-------------------------------------------------------------------------------------------------------------------

Please help, thanks in advance !!

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[blackragon]

Hi Alan, Sorry for the mistake,

Thanks for adding, will be sure to look out in the future

[karmapala]

Sorry if I'm not helping here,
just want to know more about your situation...

I'm trying to keep the rows which has the numbers shown in red ( .6. / .3. / .2. )

Will the value .6. / .3. / .2. stay the same forever ?
I mean whenever you open the workbook, the rows to keep will always the row which has the numbers shown in red ( .6. / .3. / .2. ).

or it not stay the same forever ? for example:
sometimes maybe you want to keep the row which has the numbers .2. / .1. / .0.
other time maybe you want to keep the row which has the numbers .0. / .3. / .1.
other time maybe you want to keep the row which has only the number .6.

Thank you.

[jindon]

Untested.

Please Login or Register  to view this content.

[blackragon]

Hi karmapala,

Thanks for being so kind, the post has been solved,

your help is much appreciated )

[blackragon]

Hi jindon,

Thanks for the reply. I just tested it,

Works perfect, never thought this could be done with a short and clean code like this, much appreciated.

[jindon]

Glad it worked and thanks for the rep.