getting comment
 

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

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

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

Check your other thread.

"Janice Lee via OfficeKB.com" wrote:

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

--

Dave Peterson