hmmmmm. ok! thanks for the feedback
i wonder if the original poster tried it..................
:)
susan


On Oct 22, 5:24 pm, Billy Liddel
wrote:
Yes it works but I'm not sure that I'd use it. When you resize the column
(enlarge it) the comment stays where it is and fills the middle of the cell.

Better might be

With Selection
.Placement = xlMove
.PrintObject = True 'or False as required
End With

This was recorded too

Peter



"Susan" wrote:
i didn't know it either! i just recorded a quick macro in which i
changed that property & then "stole" the code.
:D
ha ha
did you try it out? does it work?
susan