Copy Formula Code Nikki 12/31/2008 6:58:07 PM Can anyone please give me a code that copies the preceeding cell and inserts the formula only into the selected cell?

Re: Copy Formula Code JBeaucaire <JBeaucaire.3las8y[ at ]thecodecage.com> 12/31/2008 7:23:21 PM 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/showthread.php?t=45556

Re: Copy Formula Code "Rick Rothstein" <rick.newsNO.SPAM[ at ]NO.SPAMverizon.net> 12/31/2008 7:25:05 PM 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" <Nikki[ at ]discussions.microsoft.com> wrote in message news:869AEBD6-ED65-4642-8DBB-06A1CBBE75CF[ at ]microsoft.com... [Quoted Text] > Can anyone please give me a code that copies the preceeding cell and > inserts > the formula only into the selected cell?

Re: Copy Formula Code JLGWhiz 12/31/2008 8:16:00 PM 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: [Quoted Text] > > 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/showthread.php?t=45556 > >