Comment fields and links...
Posted by Hansoh on February 11, 2002 7:48 AM
if i reference a cell from an adjoining sheet (let's say sheet2) using a simple =sheet1A1 and that referenced cell has a comment attached to it, is there a way to bring view that comment on sheet2?
what if i reference that cell in sheet1 using an INDIRECT function in sheet2?
also, in PAGE SETUP, in the SHEET tab, i can choose to view COMMENTS in several ways. one way is 'AT END OF SHEET'. i can view those comments in PAGE PREVIEW, but those comments don't reside anywhere on the viewable spreadsheet, do they? do those comments have some kind of address so i can reference them in a macro? please advise. thanks in advance.