Debra Dalgleish has tons of sample code:
http://contextures.com/xlcomments03.html
maybe even:
http://contextures.com/xlcomments03.html#Reset



Perico wrote:

I succeeded in iterating through a named range to insert comments and change
their font size. But I can't figure out how to move the comment frame or
resize it. The comment extends on one line off to the right and cannot be
seen completely. I can't use autosize b/c that just gives me one long
comment off the screen.

When I implement recorded macro code to do this, I get error messages, "not
supported". (I understand the height / width properties are relative to
current position.)
How can I either reposition the comment textframe or resize it, without
using the autosize method, and avoid error messages?

--

Dave Peterson