Search worksheet for #N/A values, when foud copy entire row to another worksheet

Hi there,

I've been struggling with writing this macro.
Sheet "OUTPUT" has a vlookup formula in Column A. When there is an error in this formula #N/A appears.
I want the macro to find #N/A in Column A of OUTPUT, select the entire row, and paste it on the second line of Sheet "UNDEFINED". Then it needs to loop, as there are multiple instances of #N//A.

Any suggestions would be great!

Please Login or Register  to view this content.

Thanks so much! this worked! Much appreciated.