Delete the rows if condition match

[HaroonSid]

hello
i have data in range A1:A200, i want to delete the entire rows if condition met

i want if cell("P2").value = < 43 than delete the entire rows from a51:a200

i want if cell("P2").value = < 85 than delete the entire rows from a100:a200

i want if cell("P2").value = < 127 than delete the entire rows from a149:a200


thanx alot

[stnkynts]

A value of 5 is less than 43. It is also less than 85 and less than 127. Or do you mean this?

Please Login or Register  to view this content.

[abduljaleel.mca]

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Question what does Range("A1:200") have to do with the rows deletion if the condition is P2?

[HaroonSid]

hello ALL OF You

all method is working

thanx a lot all

will add reputation