I posted this question earlier, but I think I was unclear. I want to write a general macro that will convert a formula into a text string.
For example, instead of the numeric result of
=value(a3)
I want the macro to generate the text of the formula
'=value(a3)
so that I can copy it and paste it to another location.
Thanks for your help,
Rob
For example, instead of the numeric result of
=value(a3)
I want the macro to generate the text of the formula
'=value(a3)
so that I can copy it and paste it to another location.
Thanks for your help,
Rob