I would like to set the size of the comment box I am adding. Here i
the part of the code with the comment:

.Offset(0, 2).AddComment "Reopened: " & Date

this is all in a With statement.

Help, please.
E2

--
Message posted from http://www.ExcelForum.com

E2L,

With .Offset(0, 2).Comment.Shape
.Width = 100
.Height = 200
End With

HTH,
Bernie
MS Excel MVP


"Eager2Learn " wrote in message
...
I would like to set the size of the comment box I am adding. Here is
the part of the code with the comment:

Offset(0, 2).AddComment "Reopened: " & Date

this is all in a With statement.

Help, please.
E2L


---
Message posted from http://www.ExcelForum.com/