We help IT Professionals succeed at work.

Powershell... next Excel formatting Question

Ok,

We've determined that this works to ADD a comment:

[void] $CurrentSheet.Cells.Item($ServerRow+1,$ServerCol).Addcomment("comment")
[void] $CurrentSheet.Cells.Item($ServerRow+1,$ServerCol).Comment.Text("New comment")

BUT:  How do you set the display size of the (area size) of the comment from Powershell?

I need to size the comment so that it can be hovered over and actually read...

Probably some like a 60 x 15 like rectangle...

Thoughts?
Comment
Watch Question

Expert of the Quarter 2010
Expert of the Year 2010
Commented:
Play with the sizes, but this works well for me

$CurrentSheet.Cells.Item($ServerRow+1,$ServerCol).Comment.Shape.Width = 60 * 5
$CurrentSheet.Cells.Item($ServerRow+1,$ServerCol).Comment.Shape.Height = 15 * 12

Author

Commented:
Rock on... letme try this... Thank you!