Hi,

I have numerous cells with formulas in them, and I would like to
transfer them to other location without formulas changing.

They need to be dynamic before and after, but not during this transfer

Don't ask me why ;-)

-Sirritys

Find and replace all "=" with "~", move and change back

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Sirritys" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
| Hi,
|
| I have numerous cells with formulas in them, and I would like to
| transfer them to other location without formulas changing.
|
| They need to be dynamic before and after, but not during this transfer
|
| Don't ask me why ;-)
|
| -Sirritys
|

Should have thought about that one.

Thank you =)


Niek Otten kirjoitti:

> Find and replace all "=" with "~", move and change back
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "Sirritys" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
> | Hi,
> |
> | I have numerous cells with formulas in them, and I would like to
> | transfer them to other location without formulas changing.
> |
> | They need to be dynamic before and after, but not during this transfer
> |
> | Don't ask me why ;-)
> |
> | -Sirritys
> |

Niek Otten wrote...
>Find and replace all "=" with "~", move and change back

Unwise to use ~ since it's a metacharacter. In order to change literal
~s back to =s, you'd need to replace ~~ with =. Better to use any
character other than ~, ? or *.

I usually change "=" to "xyz=" and then back again after I've copied
them.

Pete

Harlan Grove wrote:
> Niek Otten wrote...
> >Find and replace all "=" with "~", move and change back
>
> Unwise to use ~ since it's a metacharacter. In order to change literal
> ~s back to =s, you'd need to replace ~~ with =. Better to use any
> character other than ~, ? or *.

And one more to avoid--apostrophe (').

I use $$$$$=
but only if I know that $$$$$= is never used elsewhere.

Harlan Grove wrote:
>
> Niek Otten wrote...
> >Find and replace all "=" with "~", move and change back
>
> Unwise to use ~ since it's a metacharacter. In order to change literal
> ~s back to =s, you'd need to replace ~~ with =. Better to use any
> character other than ~, ? or *.

--

Dave Peterson