Need help to solve this filter issue in VBA

Hello community members,
I just started learning VBA. I am developing a macro to automate certain task. I am stuck at one point. Need your expertise to solve it. I have given below how i expect this macro to work.

1. Open Customer feedback
2. Copy data from different columns in Customer feedback(Sheet2) to Sheet1
3. Column AV, AW, AX contains data and 0.
4. I want to replace 0 with "-" in all three column.
5. Delete Sheet2

Point to remember is its a dynamic data. In this week report 0 is starting in row 5 in column AV but it may change next week.
I tried doing it with following code and it works to some extent. Where I am stuck? While replacing 0 with "-" already present data in the same column is getting affected and either a minus sign gets added or some random weird stuff. Not sure where my code is wrong.

I would really appreciate if you guys can help me out. I have pasted entire code. If you can suggest to make it more scalable it would be lovely.

Please Login or Register  to view this content.

vba error 1.png
vba error 2.png

While replacing 0 with "-" already present data in the same column is getting affected and either a minus sign gets added or some random weird stuff.

Maybe try "LookAt:=xlWhole" not "LookAt:=xlPart" ?

Originally Posted by karmapala

Maybe try "LookAt:=xlWhole" not "LookAt:=xlPart" ?

Thank you so much. It worked like a charm