Please answer my first question
I already answered it in my last postWhat are the EXACT values when you get the error?
the error value I get is #N/A & to control this I use iferror function to not to get errors
Am I still not understanding anything ???
The sheet where the code is applied don't get any errors. As all the values in the entire sheet are copied from another sheet and pasted in this sheet as paste special value.
As far as the error point is concerned. It is there in the worksheet from where all the values are copied and pasted in this sheet and to control all the formula results which might give error I use the Iferror function.
I hope its clear now