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

--
Message posted via http://www.officekb.com