Sort on collumn H when leaving sheet

[hans]

I would like sheet "klanten" to be sorted on collumn h when i leave this
sheet to go to an other.
Worksheet_Deactivate does not seems to do the trick becaurce i have to go
back to sheet "klanten" sort and go to the next sheet.
I end up with a loop.

Can someone help?

Greetings Hans

 

[AndrewArmstrong]

Try this?

Option Explicit

Private Sub Worksheet_Deactivate()

Sheets("Klanten").Columns(8).Sort Key1:=Range("H1"),
Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

End Sub

This worked for me.
Andrew Armstrong

 

[hans]

Thanks Hans

Try this?

Option Explicit

Private Sub Worksheet_Deactivate()

Sheets("Klanten").Columns(8).Sort Key1:=Range("H1"),
Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal

End Sub

This worked for me.
Andrew Armstrong