Runtime error 9 - Subscript out of Range
Line is:
Sub Button76_Click()
'
' Button76_Click Macro
' Macro recorded 10/10/2005 by MarkD
'
' Keyboard Shortcut: Ctrl+r
'
Sheets("Spare1").Select
Sheets("Spare1").Copy After:=Sheets(74)
Sheets("Control").Select
End Sub
Any help hugely appreciated as always.
|