modify a macro; run macro again automatically for next cell if any error accurs

Hello every one,

i have got a macro which splits content of column D in sheet1 and make new entries in coulmn A and column B of sheet2.( Please refer to the picture and attached excel file.)

Now i want to process a very big wordlist with it. Some times this macro shows error cus of too long lenght of a string in a cell or because of other reasons. It shows sometimes " runtime error" and the macro stops.

Is it possible to modify the macro is such a way, that it starts again itself, if any error accours? That cell shoud be overjumped where the macro couldnt end its work (an error accoured) and that problem creating cell should be marked. For example "v" for successfully processed cells and "x" for those cells where the macro had stoped because of any error.

Please Login or Register  to view this content.

thank you very much in advance for each assistance

Hi Wali.

I looked at your file and so have several other people. They probably came to the same conclusion that I did. What is the pattern? Also, the example file did not contain the error condition you spoke of...

What is the parsing pattern?
In your next example, include data that is causing the error to be thrown.

Thanks -

Hello,
i am uploading a file containing cells, which creat error. But i cant say which one of them creat error and why. I have put the number of cell members and length of each member in col. D and col.F, so that one can know how big the cellcontent is.

heres the example:

Sorry Wali. That is more than I am willing to get into on a messageboard.

Bump