Copy formula with unchanged references

[martix]

You know - just the expression.
For example things like "=1+A1" or "=A1*B1"
Right now it changes the cells even with Paste Special!

[shg]

See Help for About cell and range references

[martix]

But how do I do it en masse? Without changing any of the references anyhow...

Here is what I figured just now - select what is to be copied; Replace [=] with ['=]; do the copy; replace back.
Do you mean to tell me that there is no other way to get the same results without all those steps?

[shg]

If you use absolute references, they won't change.

[martix]

Well I'd have to edit an already large enough dataset. Sure Excel has some form of regexes, but they are very awkward to deal with.
And still I end up with the replace function. :P
So can I assume that the answer to my previous question is - Yes, there is no straightforward way.

[shg]

I have a function that does it for a single cell -- I use it when I want to try variations of formulas, and want to make sure that the variation gives the same result.

The reason that Excel doesn't have any method (that I know of) is that people rarely want to see the same thing calculated with the same values in more than one place. Why do you?

You could use a a sub:

Please Login or Register  to view this content.

Then from the Immediate window, for example,

Please Login or Register  to view this content.

[martix]

For the exact same reason as you... For example I want to see if a pattern is preserved on other arguments/constants or the relation between the two sets of data.
Only that I use array formulas quite often.

[shg]

Here are the functions I use to copy a single formula:

Please Login or Register  to view this content.

You need a set a reference to Microsoft Forms Object Library.

If you're copying array formulas, you have to remake them as array formulas -- I never had occasion to need to do so, so the code doesn't.

[martix]

I see... well thanks