Unable to Assign Macro to Button

[atclaeys]

I keep getting an error saying that 'The formula you typed contains an error' when trying to assign the macro to a button. The macro works when I run it from the editor, regardless of which sheet I have open.

I was getting range select issues earlier so I know I'm activating sheets more than needed most likely but here's the code:

Sub R8_R12_Temp()
Worksheets("Main").Activate
Worksheets("Main").Range("D15").Copy
Worksheets("Plots").Activate
Worksheets("Plots").Range("F1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, operation:=xlNone, Skipblanks _
     :=False, Transpose:=False
Worksheets("Main").Activate
Worksheets("Main").Range("D20").Copy
Worksheets("Plots").Activate
Worksheets("Plots").Range("H1").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, operation:=xlNone, Skipblanks _
     :=False, Transpose:=False
Worksheets("Main").Activate
End Sub

Any ideas why it won't let me assign this macro to a button?

 

[VoG]

Excel doesn't like that sub name for some reason. Try renaming it to


Sub MyR8R12Temp()

 

[Datsmart]

Using a macro name beginning with an R and a number is like using a reserved name. Excel thinks you are trying to assign a Row number.
Change the name like VoG suggests and it will assign to your button.

 

[atclaeys]

Ah, that did it, thanks!