LinkBack URL
About LinkBacks
Hi
One the attached excel macro I am receiving run time error 9 subscript out of range. I am also attaching the text file that requires to execute the macro.
Please help to solve the debug.
Regards,
Vijay
Hi
One the attached excel macro I am receiving run time error 9 subscript out of range. I am also attaching the text file that requires to execute the macro.
Please help to solve the debug.
Regards,
Vijay
The array result has a first lower bound of 1 not 0.
When you get the error here, j is 0.
Please Login or Register to view this content.
If posting code please use code tags, see here.
I am getting error for the below line
result(j, n + 5) = Trim(objmatches(0).submatches(n))
That's probably because j is 0.
You'll get that error with any similar code whenever j is 0.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks