Macro to remove Rows that are 0, #REF!

[ghp2017]

Hello,

I am trying to create a macro that will actually remove all Rows where cell A1 has a value of 0, #REF !.

 

[ghp2017]

Not sure how to answer or what you are looking for. I am not a coder at all. There are no more #REF ! errors b/c there never were any. They are located in a different column, so the point is moot.