Adjust size of comment

[nsv]

I need to adjust the size of comments to a certain pre-defined value, and for this a macro should be well suited, so I switched on the recorder while making the necessary steps. The result was as follows:

Please Login or Register  to view this content.

But now when I try to run the macro on another cell I get a "Run-time error '438' Object doesn't support this property or method".

Which code will adjust the size of a comment?

NSV

[davesexcel]

Try this,
The comment needs to be visible in order to select it

Please Login or Register  to view this content.

[nsv]

I have it working now, thanks for the help.
But then I found out that setting the scale means that it multiplies the already existing size with a factor. Is it possible to define the size - in centimeters or inches or whatever unit?

NSV