Solved: Using Comments to Document Formula

[grichey]

I have the unfortunate task of documenting formula by putting the formula of a cell into a visible comment attached to the cell.

I was thinking about setting ctrl + alt + m to copy the formula into a comment. I can't figure out how to copy a formula out of a cell though as text for pasting into a comment though.

Ideas?

[marshybid]

Hi Grichey,

Have a look at this site;

http://www.mvps.org/dmcritchie/excel/formula.htm

I used the GetFormula to view formulas in adjacent cells, you should be able to use it to capture the formula then populate your comments.

Marshybid

[grichey]

Thx for the link. http://www.mvps.org/dmcritchie/excel/ccomment.htm#ccformulas got me going in the right direction.

Thanks!