how to copy formulas from one range to another range in other work

[Miri]

i need to create a macro that ask to select range of source and
destination(the destination is in other workbook.
copy the formulas of each cell to be the formulas in the destination range.
using copy and paste special causing a link between the work books. i do not
need the links.

thanks,

 

[Dave Peterson]

One way is to save that receiving workbook and then do edit|links and change
source.

But I like to change all my formulas to text:
(with the recorder on???)
Select all the cells
edit|replace
what: =
with: $$$$$=
replace all

Then copy the cells and paste.

Then do the edit|replace in reverse:

Select all the cells
edit|replace
what: $$$$$=
with: =
replace all

(In both worksheets)