copy and paste formulas between deferent workbooks.

M

Miri

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word VBA Copy Heading and Content 4
Copy columns and paste with blank column between 5
Formatting and copy or copy and formatting ?? 2
VBA code for pasting links -- modifying RDB code for summary workbook 11
Cell values to an array, then array transpose to another workbook 8
Copy FROM - TO Object/Block variable not set 6
Runtime error 438 1
Copy Array to Array, how to and should I? 13

Top