Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error 9
Hi all, I have macro below in which i am getting error on line "Set
Wks = Worksheets(myCell.Value)" and in error message it says Run-time error '9': Subscript out of range Please can any friend guide me what i should be doing Private Sub CommandButton1_Click() 'CREATE TABS Dim TemplateWks As Worksheet Dim ListWks As Worksheet Dim ListRng As Range Dim myCell As Range Dim Wks As Worksheet Set TemplateWks = Worksheets("TEMPLATE") Set ListWks = Worksheets("SUMMARY") With ListWks Set ListRng = .Range("H7:H18") End With For Each myCell In ListRng.Cells Set Wks = Nothing On Error Resume Next Set Wks = Worksheets(myCell.Value) On Error GoTo 0 If Wks Is Nothing Then TemplateWks.Copy After:=Worksheets(Worksheets.Count) On Error Resume Next ActiveSheet.Name = myCell.Value If Err.Number < 0 Then Application.DisplayAlerts = False ActiveSheet.Delete Application.DisplayAlerts = True Err.Clear End If Else Beep MsgBox myCell.Value & " already exists" End If Next myCell End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
run time error 1004 general odbc error excel 2003 vba | Excel Programming | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
Run Time Error 1004: Application or Object Defined Error | Excel Programming | |||
Conditional Formatting - Run Time Error '13' Type Mismatch Error | Excel Programming | |||
run-time error '1004': Application-defined or object-deifined error | Excel Programming |