Function to Sort a Sheet w/o selecting not working

[capson]

My Function works but only if I select the sheet first, how do I fix the code to run w/o selecting the sheet?

Thank you

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[HaHoBe]

Hi, capson,

isnīt there a dot missing before Key1?

Please Login or Register  to view this content.

Ciao,
Holger

[capson]

Hello HaHoBe, I could not get it to work even with the dot with out rewriting it to the following

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[HaHoBe]

Hi, capson,

you should consider to mark the thread as Solved via Thread-Tools over the opening post.

I put the following codes into a standard module and they worked fine for me (Win 8.1, Excel2013):

Please Login or Register  to view this content.

I started the procedure from the VBE using F8 to single step.

Ciao,
Holger