Run time error 9 Subscript out of range

[vijanand1279]

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

[Norie]

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.

[vijanand1279]

I am getting error for the below line

result(j, n + 5) = Trim(objmatches(0).submatches(n))

[Norie]

That's probably because j is 0.

You'll get that error with any similar code whenever j is 0.