LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 252
Default how ot keep value and drop formula while copying

Hi all,

I use " range.copy destination:= " to do copying between two worksheets in
two workbooks. I want to copy value instead of formula to my new sheet, how
can I do it?

Clara
--
thank you so much for your help
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Copying a Drop Down Menu Browniris Excel Discussion (Misc queries) 2 November 25th 09 11:13 PM
Copying drop down boxes ryerye Excel Discussion (Misc queries) 1 July 13th 07 04:49 AM
copying the Hyperlink function result without copying the actual formula mcheng Excel Worksheet Functions 2 June 9th 07 02:43 AM
Copying Drop Down Lists David Excel Programming 3 November 21st 05 01:26 AM
Help with copying a drop down box [email protected] Excel Programming 2 September 21st 05 01:23 AM


All times are GMT +1. The time now is 09:14 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"