Need a Macro to delete all rows containing values less than or equal 300 in column A

[dcruzed]

Need a Macro to delete all rows containing values less than or equal 300 in column A

[nathansav]

Please Login or Register  to view this content.

Begins with p and ends in lease.

[dcruzed]

Thanks for your code. It worked but if the cell value in the column is blank or some characters then it does not work. Furthermore, would you please give me a code to delete "FALSE" or "TRUE" in the first column? I tried putting the "FALSE" in place of 300 in your coding but did not work. Need your help please.

[alansidman]

You could try this:

Please Login or Register  to view this content.

[dcruzed]

Hi Alan,

Thanks so much. It worked, but I have to run the macro several times. It is a worksheet of more than 3500 rows. Can you please tell me how to get this done by one attempt of this macro run please?

Thanks

[alansidman]

Need to loop through the range backwards.

Option Explicit

Please Login or Register  to view this content.