Can anyone please give me a code that copies the preceeding cell and inserts
the formula only into the selected cell?

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" <(E-Mail Removed)> wrote in message
news:869AEBD6-ED65-4642-8DBB-(E-Mail Removed)...
> Can anyone please give me a code that copies the preceeding cell and
> inserts
> the formula only into the selected cell?

Some people do not realize that this site is visited by users from many
different countries and that some read from right to left and some read
vertically. Even worse, preceding could infer the previously selected cell
which could be anywhere. But the OP probably means the one to immediately to
the left of the selection.

"JBeaucaire" wrote:

>
> Define "preceding cell". Give specific examples of source and target
> cells.
>
>
> --
> JBeaucaire
> ------------------------------------------------------------------------
> JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
> View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45556
>
>

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" <(E-Mail Removed)> wrote in message
> news:869AEBD6-ED65-4642-8DBB-(E-Mail Removed)...
> > Can anyone please give me a code that copies the preceeding cell and
> > inserts
> > the formula only into the selected cell?
>
>