Copy Formula Code

  • Thread starter Thread starter Nikki
  • Start date Start date
N

Nikki

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
 
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.
 
THis worked Thanks a bunch



Rick Rothstein said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make cells blank IF 2
Keeping formulas on an insert 1
Entering a formula 1
Changes in How Code Acts After Upgrade of Excel 2
Insert Value into cell automatically when new rows are created/inserted 1
Insert Row also adds formulas and moves cursor 2
Replace a cell (I2) with a cell (H2) if I2 = "a" 1
HELP!!! I can't set formula to cell 1

Back
Top