Run Time Error 9: Subscript out of Range

**xyza12** · 10-30-2015, 03:17 AM

Hi Everyone,

I am very new to VBA and I joined this forum almost 2years ago, reading threads and learning from your posts. I tried coding and come across with "Run Time Error 9: Subscript out of Range"

Here's my code:

Sub CopySheet()
Set wks = ActiveSheet
Application.DisplayAlerts = False
wks.Copy Before:=Workbooks("SI Creator 1.6.xlsm").Sheets("data")
Application.CutCopyMode = False
Application.DisplayAlerts = True
End Sub

Debug is pointing this line "wks.Copy Before:=Workbooks("SI Creator 1.6.xlsm").Sheets("data")"

Thank you so much for your help.

**romperstomper** · 10-30-2015, 03:29 AM

Either the sheet name or the workbook name is incorrect.

**mangesh.mehendale** · 10-30-2015, 03:56 AM

hii change your workbook name to ("SI Creator.xlsm") and try...

It may be because of dot or digit in workbook name..

If done mark this thread as solved(see at Top right "Thread Tools").. Also dont forget to "Add reputation" to answer if anyone helps you in this forum..

Sub CopySheet()
Set wks = ActiveSheet
Application.DisplayAlerts = False
wks.Copy Before:=Workbooks("SI Creator.xlsm").Sheets("data")
Application.CutCopyMode = False
Application.DisplayAlerts = True
End Sub

Run Time Error 9: Subscript out of Range

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Run Time Error 9: Subscript out of Range

Re: Run Time Error 9: Subscript out of Range

Re: Run Time Error 9: Subscript out of Range

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Run Time error 9 : subscript out of range

[SOLVED] Run Time Error : Subscript out of range 9

[SOLVED] Run-time error '9': subscript out of range - error occurs on multiple computers except one

Run-time error '9': subscript out of range

Run-time Error '9': Subscript out of range

run time error 9 : subscript out of range

[SOLVED] run time error 9, subscript out of range

Bookmarks

Bookmarks

Posting Permissions