Help to modify Macro - delete rows that DO NOT contain a negative number.

Hello Everyone,

I am looking for some help with modifying a Macro I have:

This Macro deletes all rows that DO NOT contain the numbers 0, 1, 2, 3, 4 and 5 in column D.

I would like it if it ALSO DID NOT delete the rows containing a negative number in column D.
(The negative numbers can go from -1 to -160).

I am not sure how I can add this to the array.
I have tried adding "<>*-*" or "<0" to the array but this does not work … 


Any help would be very much appreciated!
Thanks in advance!

Please Login or Register  to view this content.

Sure!

I have attached an Excel file with a very small sample.
The table on the left is the raw data.
The table on the right is what I would like to end up with.

The rows where the numbers 6,7,8,18,27 and 45 appear in column D were deleted.
And we are left with only the rows that contain the numbers 0,1,2,3,4,5 or a negative number in column D.

The numbers in column D change every day. SAMPLE.xlsx


Thank you!!

Try the attached.

Hi HaHoBe!

Thank you for your answer!

I would rather keep it in Macro form though as this Macro is right in the middle of a larger Macro that does a bunch more things with the data.

I do appreciate the suggestion!

AB33 !!

That works perfect!
Thank you very much!

And thanks to all of you for taking the time to write back!

You have been very very helpful already but I am hoping that perhaps someone could help me with one more thing...

I have a different file where I am again using the same Macro as before. The difference in this file is that:

Instead of having a minus sign in front of the number to show a negative, the number is put between paratheses.
Like (1) (6) (18) etc...

I would like to see if it is posible to have a similar Macro as above that would keep all the numbers from 0 to 5 AS WELL as the ones in paratheses this time. (those number are also red - if that helps)

I have attached a sample of the new file and I would be eternally gratefull if anyone has any suggestions.


SAMPLE 2.xlsx


The table on the left is the raw data and the table on the right is the result I would like
As you can see in the sample, only the rows where the numbers 1,2,3,4,5 and(1),(6),(39) are present in column F remain and the rest
are deleted.

Again thank you!