Creating VBA If Statement

[tyler797]

Hi, I'm wondering if anyone would be able to help me figure out how to create an If statement in VBA. I have another thread with a different macro problem but didn't want to hijack it and confuse people with 2 problems so I created a new thread with this one. I want the macro to look at cell A1 in worksheet "CoverMirrorSheet" and if it equals "January", copy/paste (values only) A1:E34 to sheet "Data"

Thanks

 

[shg]

One way:

    With Worksheets("CoverMirrorSheet")
        If .Range("A1").Text = "January" Then
            .Range("A1:E34").Copy Worksheets("Data").Range("A1")
        End If
    End With