Hi all,
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.
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.