I have read many threads on deleting rows with certain (or no) values in cells. What I am trying to do is following:

I have a sheet containing formulas, when data is copied into the sheet (number of rows differs every time), I end up with good data for the pasted rows and the rest of rows which contain the default values and formulas (column A contains #VALUE!). What I want the script to do is only delete those remaining rows and end up with the needed data.

Because the #VALUE result is not regognized as a proper value, I haven't been able to solve this.....

Any help is appreciated.

Thanks in advance.