Having difficulty with VB on a button "Run-time error 1004"

Hi,

I'm having difficulty and am receiving an error when I launch a macros that I've embedded into a button on VBA. I created a control button and attached the macro. When I use the control button I get run time error 1004 with the message that says "Select method of range class failed."

Here's the code: (the error occurs on the {"Range ("A2").Select} line_




Private Sub CommandButton2_Click()
'
'Button226_Click Macro
'
'Keyboard Shortcut: Ctrl Shift + J
'

Range("C2").Select
Selection.Copy
Sheets("Recommendations").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Decision Matrix").Select
ActiveWindow.SmallScroll Down:=27
Range("G55").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Recommendations").Select
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Decision Matrix").Select
Range("H55").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("Recommendations").Select
Range("E2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End Sub


Can anyone help?

Thank you!

Thanks man, quick follow-up.

If insted of copying it onto A2, B2, and E2 --- say I wanted it to automoatically record the copied materials and move to the cell bellow (A3, B3, and E3), and then copy again once the button is clicked, and then once again move to A4, B4, E4

Can this be done?

I shall, thank you.

Please check the new questions here, and thanks for the help:

http://www.excelforum.com/excel-prog...16#post3303216