Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime error 9 - Subscript out of Range
The code is OK so one of the sheets you are referring to is probably not
there so ' Subscript out of range' Mike "Joe Saunders" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime error 9 - Subscript out of Range
On 26 Jul, 08:58, Joe Saunders
wrote: 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. Hi, Are you sure you have sheets named "Spare1" and"Control",and there are more than 73 sheets in your workbook? No to any of those will cause the error - You can't select something that is not there.... Tony |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Runtime error 9 - Subscript out of Range
I see the problem now, spare1 was renamed!
Thanks for your help guys. "bony_tony" wrote: On 26 Jul, 08:58, Joe Saunders wrote: 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. Hi, Are you sure you have sheets named "Spare1" and"Control",and there are more than 73 sheets in your workbook? No to any of those will cause the error - You can't select something that is not there.... Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
runtime error 9 subscript out of range | Excel Worksheet Functions | |||
Runtime Error 9, Subscript Out of Range. When linking between word | Excel Discussion (Misc queries) | |||
Runtime Error 9 Subscript Outta Range | Excel Programming | |||
Runtime Error '9' Subscript out of range HELP | Excel Programming | |||
Getting Excel Runtime Error 9: Subscript out of range | Excel Programming |