delete entire row when value is found

dear all,

below part of my code inside a user form .
I am trying ,once the value is found to delete the entire row but no success (get an error on the line "hawb2.entirerow.delete").
can someone help ?

Please Login or Register  to view this content.

Hi there,

Your code worked for me - see the attached workbook. Is your worksheet protected?

Regards,

Greg M

..you got the point!!!! I do not realized sheet is protected ! ....tks so much......

Hi again,

Many thanks for your feedback - glad I was able to help.

You're very welcome - sometimes it's the little things in life that cause the BIG problems!

Best regards,

Greg M