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

Posted to microsoft.public.excel.programming

Miri

external usenet poster

Posts: 62

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

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,

--
Miri Tz.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formulas assignment from array to range in VSTO Excel doesn't work	vsto excel array to range	Excel Worksheet Functions	0	December 11th 07 04:48 PM
Copy a named range from an installed add-in while in anothter work	Chip Pearson	Excel Programming	0	January 5th 07 10:58 PM
Copy a named range from an installed add-in while in anothter work	Dave Peterson	Excel Programming	0	January 5th 07 10:52 PM
copy formulas from a contiguous range to a safe place and copy them back later	Lucas Budlong	Excel Programming	2	February 22nd 06 08:26 PM
Range COPY function - how to copy VALUES and not formulas	James Cooke	Excel Programming	1	August 21st 03 07:04 PM

All times are GMT +1. The time now is 05:06 PM.

Menu

About Us