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.

try changing,

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

adds a new sheet with the x string value, if that sheet name doesn't exist already