| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Annoying Problem - Subscript out of range
Anthony wrote:
Hi, The problem I am having is only occurring on 2 pc's. I have run the code on numerous other machines with no issues, but the annoying thing is I need it to run it on one of the pc's that is having the subscript out of range error. I have attached the two spreadsheets. The master file is meant to open up the office file and load in any information. The code is written so the user can select multiple files and it will work its way through them. The code is not very fancy but it was something I was putting together in a hurry and I was going to go back through the code and clean it up etc. What I don't understand is on the machines it failed on, the code in module 2 (Button2_click) fails during the function; e.g (sample of what I have descriped) fname="Tracker file" Workbooks.open(fname) 'ok Workbooks(fname).sheets("sheet1").select 'fails - subscript out of range Any help would be gratefully received. I apologise for having to attach files. Anthony p.s password is dragon1 different regional setting and "sheet1" is not "sheet1" ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Annoying Problem | Excel Programming | |||
| Subscript out of range problem | Excel Programming | |||
| Subscript out of range problem | Excel Programming | |||
| Subscript out of range problem | Excel Programming | |||
| Excel Macro Problem, Add-in need to work in every workbook & Error:9 Subscript out of range | Excel Programming | |||
Threaded Mode
