copy and paste formulas between deferent workbooks.
 

hi,
i need to copy the formulas of spesific range in one work book to other
range in other work book.
i would like to do it by macro.
copy and past special caused a link between the two worksheets. i do not
need the link.
i want to write something that will ask for selection sorce range and target
range, scan every cell, copy its formula to the target range. please
help.thanks.
--
Miri Tz.