View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Macro to Insert Comment to a cell

The =echocomment() would be used instead of the link:

So
=if(sheet1!a1="","",sheet1!a1)
would be replaced with
=echocomment(sheet1!a1)

You have to do it to each formula.

wojo wrote:

If this is how I would "link" the comment , attached to a cell... to
another worksheet where the cell has been linked, where does the
=echocomment(a1) go? There are hundreds of linked cells.

Not sure how to use this information.

Jo


--

Dave Peterson