Help to code not work on Sheet with many rows and columns.

Hi I have below code. It was working on a test sheet but when i now try it on a very big file it give me an error.
The code sort the rows in a chosen column. And add sheets with that name. So if in column Austria is there, it will create a sheet called Austria and put all rows with Austria in there. The File i am working with have 100 columns and 115806 rows. It give me this error message in the red field.

ActiveSheet.Name = x

The name is all ready taken try a new one.


Please have a look i cant off course attach a so big file. But would be happy if some know and can help with that.

Thanks in advance

Sincerely

Abjac

Please Login or Register  to view this content.

HI Generaldisarray. I think your right. I have not been thinking on that. I tried to move Denmark in testsheet before. And now it made the same error.

So the code are not really perfect. They can come in different order. UPS. But i think this is the error.

I have attached a testsheet and this time put them in various order. Please i really need a code which can do that. Dont know if the existing can.

But please have a look thanks

Sincerely

Abjac

Hi abjac,
try this

Please Login or Register  to view this content.