View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe Saunders Joe Saunders is offline
external usenet poster
 
Posts: 5
Default 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.