PC Review


Reply
Thread Tools Rate Thread

copy and paste formulas between deferent workbooks.

 
 
=?Utf-8?B?TWlyaQ==?=
Guest
Posts: n/a
 
      6th Jun 2007
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't Copy and Paste or Paste Special between Excel Workbooks =?Utf-8?B?d2xsZWU=?= Microsoft Excel Misc 7 3 Days Ago 07:00 AM
How do I copy and paste formulas between workbooks? =?Utf-8?B?dGV6emE=?= Microsoft Excel Misc 4 6th Jul 2006 06:53 PM
paste formulas between workbooks without workbook link ron Microsoft Excel Misc 2 12th May 2005 05:10 PM
How asign deferent contex menu to deferent treenode =?Utf-8?B?U2VyZ2V5IFJvbWFub3Y=?= Microsoft C# .NET 1 24th Sep 2004 06:10 AM
Copy formulaS between Workbooks Syslock Microsoft Excel Discussion 4 12th Nov 2003 04:56 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:12 AM.