senators40
Technical User
I would like to use the properties of cut for a formula while still maintaining the original place where the formula resided.
For instance if the formula is in cell A3 =Sum(A1:A2)
I want to move it to cell B3 and have the formula in B3 be =Sum(A1:A2) and still have cell A3 have =Sum(A1:A2)
I know you can use absolutes (with the $) to do it but sometimes the formulas are more complex
Manually I insert an apostrophe ' in front, then copy then paste to another cell and remove the apostrophe from both items. It works but I would like to know if there is a quicker way to do this through a macro.
Any help would be appreciated
Thanks,
Jeff
For instance if the formula is in cell A3 =Sum(A1:A2)
I want to move it to cell B3 and have the formula in B3 be =Sum(A1:A2) and still have cell A3 have =Sum(A1:A2)
I know you can use absolutes (with the $) to do it but sometimes the formulas are more complex
Manually I insert an apostrophe ' in front, then copy then paste to another cell and remove the apostrophe from both items. It works but I would like to know if there is a quicker way to do this through a macro.
Any help would be appreciated
Thanks,
Jeff