Copy / Paste Special Values Script

Hi All

My command button is on a different worksheet to where the copy/paste needs to occur. I originally had the command button on the same worksheet with the following code:

Private Sub CommandButton9_Click()

Sheets("summary").Select
Range("CH45:CH61").Select
Selection.Copy
Range("CG45:CG61").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Range("CH73:CH78").Select
Application.CutCopyMode = False
Selection.Copy
Range("CG73:CG78").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Range("CH82:CH96").Select
Application.CutCopyMode = False
Selection.Copy
Range("CG82:CG96").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Range("CH112:CH119").Select
Application.CutCopyMode = False
Selection.Copy
Range("CG112:CG119").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Range("CH124:CH136").Select
Application.CutCopyMode = False
Selection.Copy
Range("CG124:CG136").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Range("CH140:CH151").Select
Application.CutCopyMode = False
Selection.Copy
Range("CG140:CG151").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

End Sub

now that i have moved the command button to a different sheet, and tried to cut the above code into the private sub command of the new sheet (sorry if my language is not correct), it does not work...

what should i be doing different to make it work?

Jason

there are no error messages, it just does nothing...

its very sensitive information as it is a sales forecast and financial outlook....is there any other way to do this?

ok sorry, but i do get an error: runtime error 1004, Select method of range class failed...after debugging it stops on the second line of code (range)

change works perfectly...every so greatful mud!!