Microsoft Excel 2010 VBA Macro Programming Problem

I've done quite a bit of research and I've come up with the following macro which doesn't run successfully. Just to say, WorkBook1.xlsm and WorkBook2.xlsm are in the same folder and they each have only one work sheet.:

Question

Microsoft Excel 2010 VBA Macro Programming Problem


I've done quite a bit of research and I've come up with the following macro which doesn't run successfully. Just to say, WorkBook1.xlsm and WorkBook2.xlsm are in the same folder and they each have only one work sheet.:

s3a · Answer

Sub MySelfMadeMacro()

    Application.ScreenUpdating = False

    Workbooks("WorkBook1.xlsm").Activate
    Worksheets(1).Select
    Range("B2:C3").Select
    CurrentRegion.Copy
    
    Workbooks("WorkBook2.xlsm").Activate
    Worksheets(1).Select
    Range("E1:F2").Select
    ActiveSheet.Paste
    
    Application.ScreenUpdating = True
    
End Sub

s3a · Answer

The Microsoft Visual Basic compiler says:
Run-time error '424':
Object required

and suggests that the
CurrentRegion.Copy
syntax is what's at fault.

I'm thinking that I need to make an object for a clipboard or something so that I can run that operation but I'm confused as to how I should proceed from here.

Any help in finding the missing syntax would be greatly appreciated!