Thread: Copy and Paste cells with formulas without formula adjustment

I would like to copy a range of cells (interactively) which contains formulas with references to other cells. By default, the references in the target cells will be adjusted by the relative offset of the destination cell to the source cell (unless the reference is absolut, i.e. $A$1).
I'm looking for a way, that this adjustment is not applied without using absolut references in the source cells, i.e. copy literally.
Paste Special only allows me to either select 'formula' (with adjustment) or 'value' (but I need the formulas!) - so 'paste special -> literally' would be nice...

Is there a way to achieve this?

Many thanks in advance!

Try replacing = with something like #, copy/paste, replace # with =

maybe try like this:

copy the formula to notepad, then replicate it the amount of times you need (let's say you wanna spread it to 10 cells, then replicate it 10 times), copy the text from notepad, then paste it back to excel.

Originally Posted by Armando Montes

Try replacing = with something like #, copy/paste, replace # with =

Nice idea (like all the others!) - I will try this!

Many thanks! What is the right/best function to copy with a macro?