| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Formula Code
Can anyone please give me a code that copies the preceeding cell and inserts
the formula only into the selected cell? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Formula Code
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Formula Code
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy Formula Code
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to Copy a Formula to Multiple Sheets Q | Excel Programming | |||
| copy formula using VB code | Excel Discussion (Misc queries) | |||
| copy and paste formula using vb code | Excel Discussion (Misc queries) | |||
| Code to copy formula to variable range | Excel Programming | |||
| Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming | |||
Linear Mode
