Hi first run its working for second run its giving error like “If: Index was outside the bounds of the array.”
This error means that one of your split methods failed to find the item you were searching.
I suggest you use the ‘write line’ to print to the output window the text of column 4, so you can better take a look at the issue.
Can you show the data fields on excel.
And tell that actually what you are trying to do with it
Er Pratik Wavhal
yes i had some empty cells , how i can overcome this issue .
place a if condition for checking empty rows
row(4).Tostring <> “”
to overcame this you can use the len(row(4).toString")> 0 prior to the if.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.