Sort tables in other sheet with VBA

[martinpaiva]

Hi All,

I have the follwing code to sort two tables. This code works when its executed in the sheet where the tables are stored. But I want to move this code to another sheet and execute it when that sheet is selected.

For some reason i get the folliwing error: "Application-defined or object-defined error"

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[martinpaiva]

Hi Norie,

Now works Thank you so much for your help !!!