Copy Formulas

[stefanborries]

Hi,

here is my problem and I hope someone can help:

I want to copy a specific range in a sheet with all the formulas to an other Excelfile.
So far so good, here my problem begins.
I don't want the formulas to be connected to the source sheet but to the cells in the sheet in the new file.
Is it possible to do so with Excel 97?

I tried copy sheet / copy paste / copy pastespecial formulas / copy pastespecial values / copy pastespecial all

It was all the same (except for values). Excel allways connect the formular to the source file.

I hope somebody can help.
Thanks in advance...

[GlennUK]

Change the formulae to text, then copy and paste then convert them all back to formulae.

To do this select the formulae, do Edit/Replace and change = to # and press Replace All. This changes all the formulae to text, so then do the copy and paste.

Select your copied text, and do Edit/Replace changing # to = pressing Replace All, and hey presto you now have formulae again. Remember to change back your source cells as well.

Cheers, Glenn.

[stefanborries]

Thanks for the quick reply.

Works really great, but if someone knows a quicker easier, much more comfortable work, feel free to tell me...

[stefanborries]

Okay, doesn't work the way I wanted it.

I cannot change the '#' back to '=' via macro.

But I can copy the formulas by:

destinationcell.formular1c1 = sourcecell.formular1c1

Works nice, but isn't as quick as replaceall.

I have opened the replacedialog via macro but it didn't the same job as the replace-dialog you can open in the menu.
Strange :o