![]() |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
Sub main()
Dim i As Integer Dim wrk As Workbook Dim wsh As Worksheet, wrk_Name, wsh_Name, prmpt As String prmpt = "Enter Workbook name:" wrk_Name = Application.InputBox(prmpt) prmpt = "Enter Worksheet name:" wsh_Name = Application.InputBox(prmpt) Set wrk = Workbooks(wrk_Name) 'This line gives error '.... end sub |
| Tags |
| worked fine previously. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Runtime error '9': Subscript out of Range | KingoftheKassel | Excel Programming | 1 | 06-13-2016 08:00 PM |
| Error: "Changes made were lost...reconnect with server", when switching "from" field | randhurrle | Outlook | 2 | 02-25-2015 06:51 PM |
| Loop through folder of workbooks and copy range to other workbook | Snvlsfoal | Excel Programming | 3 | 07-29-2011 05:55 AM |
Subscript out of range error
|
KHTAY | Excel | 6 | 03-28-2009 11:18 PM |
Mysterious "Subscript out of range" error
|
rnstewart | Excel | 4 | 12-29-2005 01:04 PM |