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
|