I am getting an error with Comments. I am inserting a comment for each row in the workbook, and there are several hundred rows. I would like to have the comment formatted in "Courier New" font, which I set when I create the comment.
Unfortunately, this exceeds the number of fonts allowed in Excel. I think each time you set a font property in a comment, it eats up a font object.
There doesn't seem to be a way to share the font settings between comments, or point to a shared style? The font property in the comment is read only.
Is there a workaround, or could the comment object be extended to share a font object?
Thanks
Mitch Stephens
Hi Mitch,
I will check and fix this issue ASAP.