I have a VLOOKUP formula in cell B6 which returns a value of #N/A. How can I test that cell (in another cell) for such an error ?
but that doesn't work. How would I also test for this in VBA ?
Thanks in anticipation