Filter and Delete Rows

Hi Friends

In the attached, i want to filter Column F by 0 and remove those rows. Can you please help me to write macros? When I record, it doesnt do the job property due to change of 0 in different rows.

Is it possible to write without Dim function just to make it easy?

Thanks a lot in advance

Try

Please Login or Register  to view this content.

Thanks a lot Jindon

Can you please advise what can be amended to include multiple instead of just one like "-", "100", "200" etc.

Thanks again for your help

Originally Posted by arpanpanchal

Thanks a lot Jindon

Can you please advise what can be amended to include multiple instead of just one like "-", "100", "200" etc.

Thanks again for your help

Should be like this

Please Login or Register  to view this content.

Thanks a lot everyone..This is great