VBA code to copy specific range

[Alteran]

I am trying to get VBA to allow me to select a specific range of cells to copy, however it keeps giving me an error when I do the range select, I have tried this two different ways and still get the same issue can anyone help me out with this?

#1:

        'Select the data wanted
        Sheets("Combined Data").Select
        Range("A3:BN3").Select
            'Copies the Data
            Selection.Copy
                'Back to original Sheet
                Sheets("Administration").Select

#2

        'Select the data wanted
        Worksheets("Data2").Range("A3:BN3").Select
            'Copies the Data
            Selection.Copy

 

[VoG]

There's no need to select anything

Worksheets("Data2").Range("A3:BN3").Copy

 

[Weaver]

There's no need to select the data first

Worksheets("Data2").Range("A3:BN3").Copy

Which might be the answer if Data2 isn't the currently active sheet.

 

[Alteran]

Doh! yeah that worked Thanks VoG... its just to early in the morning for me I guess!