Add comment to special cells

[ajaykgarg]

Hello

I am highlighting cells with errors ("#N/A") using the code below (else part).
I got an error when trying to add comments to such cells.
How can I modify the code below to add comments to all cells with errors?

Please Login or Register  to view this content.

Thanks in advance
Ajay

[royUK]

What error message?

SpecialCells will give error messages if there are no cells to match the type

[ajaykgarg]

I should have mentioned this earlier.
I am populating this column using Vlookup as follows:-

Please Login or Register  to view this content.

If a value is not found in lookup, I will get #N/A error.
I am highlighting such cells using code below:-

Please Login or Register  to view this content.

Now, in addition to highlighting these, I also want to add a comment asking users to update missing values in lookup.
For that, I was trying to add following code:-

Please Login or Register  to view this content.

This gives error "Invalid procedure call or argument".
So, I am looking for a work-around to identify all cells with "#N/A" errors, and add a comment to them.

I hope the problem is clearer now.

Thanks
Ajay

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!