Hi,
I got error , it says "Subscription out of range", run time error.
I was doing copying and paste in another workbook from Master workbook.
End Sub
Please Login or Register to view this content.
How can I solve the Subscription out of range error?
Thanks
The error is "Subscript out of range".
GetSaveFileName doesn't exist. Did you copy and paste this code, or type it into your post?
On the hunch that your code really says GetSaveAsFileName, I ran this code and it ran perfectly. I suggest you post all of your code.
This error would be caused by fname not being a valid Excel workbook path. Run your code, and when it stops on that line, hit CTRL-G, type
print fnameand then copy the result and paste it here so we can see what the value of fname is at that point in the code.
Chances are that fname is not declared or named properly. Look further up in the code and hover your cursor over fname as you step through the code. Is the directory / path correctly set?
You will probably need to post your entire code if you can't figure it out. Then we can help.
If I helped in any way, please click the star
This is my code and please help me.Please Login or Register to view this content.
Thanks
Last edited by Goodstart14; 10-20-2014 at 10:18 PM.
Thanks, I posted my code and I think I got '\' because I used GetSaveAsFilename.
I don't know how to fix this.
If you cancel the second GetOpenFilepath, it will error. you need to add a line
I'm also puzzled by the "Do you want to see" message box. As written the only button available is OK, but the prompt suggests that No should be an option.Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Yes, you are right. I was hurry.Originally Posted by mikerickson
If you cancel the second GetOpenFilepath, it will error. you need to add a line
I'm also puzzled by the "Do you want to see" message box. As written the only button available is OK, but the prompt suggests that No should be an option.Please Login or Register to view this content.
Thanks.
I fix my code.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
EDIT: Thanks for marking the thread as solved.
Good luck.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
No, my question was about error 'Runtime 9, subscription out of range'.
Thanks
Is there I can error handle 'Run time error 9'?
Thanks
The error is Subscript out of Range.
The code you posted is quite different than what you put in your first post. You are getting a filename from GetOpenFilename. sFilename should be declared as Variant, not String, because the function can return FALSE if the user cancels the operation. In that case you will get a subscript error. However, you did not do what I suggested, which is to check the value of sFilename when the error occurs and tell us what it is. So this is the best I can suggest:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks