Hi Louis,

What if I do not want to use codes. Instead, I want every "R" cell to
display a different content, i.e. an independant comment for each. Is that
possible?

The codes are intended to provide a means to link a cell to its comment,
which is held on a separate worksheet. Without the code, how will the
appropriate comment be displayed. It would be feasible to use the cell's
address as the key, but, clearly, this would fail if rows or columns were
inserted in the main sheet.

Therefore, rather than using a simple 'R', try using R1, R2...Rn to
designate your comment cells. If you wish your users only to see the 'R',
why not set the font colour of the appended numeric to match the colour of
the cell background?


---
Regards,
Norman