Index was outside the bound of the array in Excel Loop

vishakharkolhe · May 12, 2020, 11:07am

Hi,

I am facing the attached issue while using excel loop. What could be the reason of this?

amit_anand15 · May 14, 2020, 3:49am

Hi,

When are you observing this error.

At the start of loop.
For some specific row
or
All row have been processed and then you are getting this error

vishakharkolhe · May 14, 2020, 1:11pm

Hi Amit,

I am using excel loop inside while loop. I am trying to execute that while loop till the length of array-1. For 1st value of Array (arr(0)), it is giving output but while executing next iteration that is for 2nd iteration, am facing this issue.