I am using a VBA routine to (try to) open an Excel file.
I've used this routine before without a hitch. I am now trying to use it again in a new procedure.
However, I'm getting "subscript out of range" when I try to run it. That error message tells me absolutely nothing.
(novice VBA, besides).
The function prompts for a file and should open it into the existing workbook and name the sheet "Input".
This is the function:
Please Login or Register to view this content.
What nonsense!!! I just moved the macro from the ThisWorkbook to a Module and it works. Crazy.
Hello krweaver,
A Subscript out of Range error occurs when you attempt to access an element of an array or Collection that does not exist.
Which line throws the error?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks