Copy Formula Code
THis worked Thanks a bunch
"Rick Rothstein" wrote:
Did you want an identical copy of the formula (same range references)...
Selection.Formula = Selection.Offset(, -1).Formula
Or did you want the range reference to update for their new location...
Selection.Offset(, -1).Copy Selection
--
Rick (MVP - Excel)
"Nikki" wrote in message
...
Can anyone please give me a code that copies the preceeding cell and
inserts
the formula only into the selected cell?
|