Problem with code when inserting row at worksheet

[celiel]

Hello all.

I have the following code. In some cells in the worksheet there is data that is separated with "," for example "kkkkk,ddddd" and I want to separate the data where the "," is found and put each string found to the cells bellow, and copying the remaining row.

The code works fine in the test worksheet. The only change that i did was to change the name of the worksheet. When I run it i always get runtime error 1004 Application-defined or object-defined error when i am trying to insert a new row.

I cant figure out the problem. The only thing that I think it can cause problem is that the button is in a different worksheet than the code is referring to.

Please Login or Register  to view this content.

[royUK]

This wrks for me, but it's really slow.

Please Login or Register  to view this content.

A dummy workbook would help, I'm sure you are checking too many cells

[celiel]

Thanks a lot for your help.

Ok something peculiar. When I created a new button to the worksheet with the data, it run fine.
When i run it from a different worksheet i always get the error.

I have also tried to run the code at excel 2010 and the button created at the worksheet with the data and i got the 1004 error -- insert method of range class failed.

The worksheet with the data has about 20,000 rows filled with data. Is there a limitation to the insert method ?

I can't figure out the problem except that I have too many cells.

Tomorrow I will try to post a dummy worksheet, because i am not at work.

Thanks in advance.