Excel Experts,

I've inherited a spreadsheet that has dozens of comments and they're all
located about six columns away from the cell they comment on.

Is there VBA code that would move all my comments to say, 1/2 inch to the
right of the parent cel?

I tried to use the Object Browser to figure this out but couldn't get my
answer. It seems, the Comment Object has a Shape (property? object?) which
has a few memebers(?) which seem promising, such as "Connector" and
"Placement".

Also, isn't there some view in the VBE that lets me see all the properties
of an object? Where I could look at a cell with one of these wayward
comments, and then see the comment, and see the comment's Connector property
or Placement property, and make changes to the values?

Thanks in advance,

Alan

--
achidsey