View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
dominicb[_78_] dominicb[_78_] is offline
external usenet poster
 
Posts: 1
Default VBA - Passing Cell Contents Into Comment


Hi ajocius

The fact that there might have been a comment in the cell never
actually occurred to me. If you want to edit a comment, then you miss
out the .AddComment command - this is only used to add a new comment.

I must admit to being a little confused as to why you reported this
instruction as halting the program - glad you got it sorted and pleased
to have helped out in some way.

Take care

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=391261