Home |
Search |
Today's Posts |
#7
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Paste selected Range from Excel to Outlook with Disclaimer Statement & Signature | Excel Discussion (Misc queries) | |||
copy selected rows to second worksheet (NOT Cut + Paste) | New Users to Excel | |||
Macro to copy & paste-special-values data to selected worksheets | Excel Discussion (Misc queries) | |||
copy and paste range of cells excluding hidden data in excel | Excel Discussion (Misc queries) | |||
How I can copy / paste a selected cells to other columns in Excel | Excel Discussion (Misc queries) |