My macro:
Code: Select all
Sub copy()
Sheets("X").Range("A1:C10").Copy Sheets("Y").Range("A1")
Application.CutCopyMode = False
End Sub
Thank you very much
Code: Select all
Sub copy()
Sheets("X").Range("A1:C10").Copy Sheets("Y").Range("A1")
Application.CutCopyMode = False
End Sub
Code: Select all
oSheetX = ThisComponent.Sheets.getByName("X")
oSheetY = ThisComponent.Sheets.getByName("Y")
oSource = oSheetX.getCellrangeByName("A1:C10")
oTarget = oSheetY.getCellrangeByName("A1")
oSheetY.copyRange( oTarget.CellAddress, oSource.RangeAddress)
Code: Select all
Application.CutCopyMode = False
I don't know VBA or Excel. Just a guess: An Office application (component?) has a property controlling the general way a copy command is working: like Ctrl+C or like Ctrl+X. Assuming the posted Sub started with Application.CutCopyMode = True (Work like Ctrl+X!) it sets the Ctrl+C mode at its end.FJCC wrote:I don't know whatmeans.Code: Select all
Application.CutCopyMode = False
Code: Select all
oSource.RangeAddress.ClearContents(CellFlags)