Copy formulas exact without references changing
"mikeburg" wrote in
message ...
Trying to come up with a VBA procedure to copy a cell formula exact into
the clipboard that I can paste (cntrl+V) in any other desired cells
without the references changing. That way, I can assign the keys
Shift+Ctrl+E to the procedure for a short cut. I know about the $ but
there are too many formulas to edit.
I now do it manually as follows:
On the desired cell, F2
Ctrl + Shift + Home
Ctrl + C
Esc
Any ideas?
mikeburg
Dim A as String
A = [B50].Formula
Ciao
Bruno
|