Excel VBA实现复制单元格区域到另一个Sheet

2015/02/17 17315 

    Sheet1.Range("A2:B9").Select
    Application.CutCopyMode = False
    Selection.Copy
    Sheet2.Select
    Range("B3").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks :=False, Transpose:=False
    Application.CutCopyMode = False

编程技巧