getting comment

  • Thread starter Thread starter Janice Lee via OfficeKB.com
  • Start date Start date
J

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
 
sorry, my bookmark was set at march 2005, so i thought my posting was
removed!
 
Check your other thread.

Janice Lee via OfficeKB.com said:
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
Click to expand...
 
Back
Top