getting comment

[Janice Lee via OfficeKB.com]

not sure why the posting got deleted.

i have multiple sheets and some cells are self-referencial of another on
different sheet of the same workbook.
is there a way to also capture the comment with an equal sign?

for example, I want sheet1 A1 to not only get the cell value of sheet2 A1,
but also get the comment of sheet2 A1.
_______________________________________________
sheet1
A1: =sheet2!A1

sheet 2
A1: = value with comment inserted

 

[Janice Lee via OfficeKB.com]

sorry, my bookmark was set at march 2005, so i thought my posting was
removed!

 

[Dave Peterson]

Check your other thread.

not sure why the posting got deleted.

i have multiple sheets and some cells are self-referencial of another on
different sheet of the same workbook.
is there a way to also capture the comment with an equal sign?

for example, I want sheet1 A1 to not only get the cell value of sheet2 A1,
but also get the comment of sheet2 A1.
_______________________________________________
sheet1
A1: =sheet2!A1

sheet 2
A1: = value with comment inserted