I would like to automate the following process that places
the formula for a particular cell, say Axx, into cell Bxx
when cell Axx is selected. BUT, I want the formula in cell
Bxx to be preceded by the characters: 'Axx:' (without the
quotes) so that it is displayed on the screen as an
annotation.
I can do all this manually but I do not know how to produce
a macro or cell-formula that will get the actual formula
from a cell. For example, =CELL("contents",A1) gets the
results of the formula in A1, not the formula itself.
Thank you.
(B=)
Brian Schott/Decision Sciences Dept. (404) 651-4070 [log in to unmask]
J Mack Robinson College of Business / Georgia State Univ
Atlanta, Georgia USA 30303-3083 interests: approx. reasoning,
http://www.Gsu.EDU/~dscbms/ (B=) decision support systems
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
|