using Vlookup function in an excel sheet, the result in some cells is #N/A.
I am writing a macro to find and process these cells but if I write "If
range("A1").value = "#N/A" I am getting an error . How can I identify these
cells in a macro.