LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default How to Copy & Paste selected Range in Excel (MFC)

I know how to do about it, it's simple, :-)

COleVariant varRange2;
varRange2.vt = VT_DISPATCH;
V_DISPATCH(&varRange2) = (LPDISPATCH)range2;
V_DISPATCH(&varRange2)-AddRef();
range1.Copy(varRange2);

Thanks at all!


"Daniel Xu" ????
...
HI, I mean use VC6.0 (MFC), not Delphi, how to translate?

-----Original Message-----
HI,you can try this:
Range("a1").Copy Destination:=Range("b1")
Application.CutCopyMode = False

or range("a1").copy
range("b1").paste



.



 
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
Paste selected Range from Excel to Outlook with Disclaimer Statement & Signature Arnold1226 Excel Discussion (Misc queries) 0 November 11th 10 09:57 AM
copy selected rows to second worksheet (NOT Cut + Paste) gyrra New Users to Excel 2 June 4th 10 09:05 PM
Macro to copy & paste-special-values data to selected worksheets tomhelle Excel Discussion (Misc queries) 1 May 5th 10 02:00 PM
copy and paste range of cells excluding hidden data in excel Steve22055 Excel Discussion (Misc queries) 3 October 23rd 08 01:57 PM
How I can copy / paste a selected cells to other columns in Excel M.Rafat Excel Discussion (Misc queries) 4 November 7th 06 05:42 AM


All times are GMT +1. The time now is 12:47 PM.

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"