This problem is not consistent. Sometimes the code works sometimes it doesnt i cannot track down the problem...
In the same module i run the following code:
I first run:
Then I use those variables here:
Please Login or Register to view this content.
It throws:Please Login or Register to view this content.
" runtime error 9, subscript out of range"
What am I doing wrong. They are public variables?!
Last edited by iamGreenhorn; 07-22-2014 at 04:16 AM.
And there's definitely sheets witht the names specified in curMI and curOOT?
If posting code please use code tags, see here.
It creates those sheets
But It throws the error here:It is suppose to stop the sub before it creates a blank sheet and throws a already exists errorPlease Login or Register to view this content.
If there isn't a sheet with the name the same as the value in curMI you will get a subscript out of range error.
I used to use the curOOT variable and set it to a sheet and it would throw the same error..
How else do you check if a sheet exists without this error, this is the best i could find online without getting super complicated.
There are lots of ways to check if a sheet exists, here's one.
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