Hello there,

I have a sheet with 56K lines in sheet1, I need to hide some of lines and delete some of lines in the sheet1 with macro.

For exp, which contains "AB.01" in A column so delete all the lines starting "AB.01" and wihch contains "BB9.1" hide all the rows which is starting "BB9.1" in the sheet1.

I tried like *AB.01*, *A*B*.*0*.1* somethings but couldnt do it.

Thank you for your help!