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/