Possible using VBA to sort a Non-Active Sheet?

[keithmcvean]

I have a macro tied to a button on a sheet called "Programs". As part of the code of this it sorts a named range "Setting_Employees" on a separate sheet called "Settings".

Ideally, to keep the macro from flipping around the active sheets I was hoping to sort a non-selected, non-active sheet. So far I haven't been able to make this work.

This code works but, as I said, I was hoping to do this without making the Settings sheet active. Is it possible?

Worksheets("Settings").Select
Range("Setting_Employees").Sort Key1:=Range("Setting_Employees").Cells(1, 1), _
Header:=xlNo, OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom, DataOption1:=xlSortNormal

Thanks in advance,
Keith

 

[wrightyrx7]

Why don't you just make the sheet you started on active again at the end of the code?

Maybe turn screen updating OFF so you don't see it changing sheets visually.

 

[wrightyrx7]

Or try this

Worksheets("Settings").Range("Setting_Employees").Sort Key1:=Range("Setting_Employees").Cells(1, 1), _
Header:=xlNo, OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom, DataOption1:=xlSortNormal

 

[keithmcvean]

Thanks. That seems to have worked.

 

[wrightyrx7]

No problem, thank you for the feedback