View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
L. Howard Kittle L. Howard Kittle is offline
external usenet poster
 
Posts: 698
Default XL2003: Move a Comment Into a Different Cell?

Hey Daddy,

No need to copy to new cell and delete from old cell. Select the old cell
and move your cursor to the edge of the cell untill you get a four-sided
arrow and left click and hold and drag to new location and release.

As far as "... Excel can't do this on its own-" I would say the drag and
drop is about as 'on its own as you can get'. Maybe the down side of drag
and drop is that the cell contents goes with you on this method.

Dave P's code will likely be as top notch as it gets using the macro route.
The cell content does not follow to the new cell. If you want that feature
in Dave P's code add this just above <FromCell.Comment.Delete line :

FromCell.Copy ToCell
FromCell.ClearContents

HTH
Regards,
Howard


"Daddy" wrote in message
...
Is it possible to move a comment into a different cell?

For example: I have a comment in cell B4; can I move it to cell A4?

I realize that I could always copy the comment to the new cell and then
delete the comment in the old cell, but surely there's an easier way?
Copy-and-delete becomes tedious when you have to do it for dozens of cells
individually.

Daddy