View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Miri Miri is offline
external usenet poster
 
Posts: 62
Default 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.