Thursday, February 20, 2020

How to copy one sheet to another using vba


 Please paste these lines in VBA macro.
        Sheets(SourceWS).Range("A1:G99").Copy Destination:=Sheets(DestWS).Range("A1") 'Temp
        Application.CutCopyMode = False

No comments:

Post a Comment