View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default Add comment and resize it

I have code that I am trying to put in a comment and sesize it. I can
not figure out the part how to resize them.
If i.Offset(0, 6).Value = "Realm" Then
Set shp = i.AddComment("")
'Size?????
Else
Exit Sub
End If

Thanks,
Jay