Sorting

J

JoeyJoeJoe

When you try to sort two or more cells when there are adjacent cells you do
not want to sort, Excel gives you a sort warning. How do you stop this
warning from appearing?
 
S

swisse

You could make a sort macro and at the beginning of the macro write:
Application.DisplayAlerts = False
and at the end of the macro before the End Sub write:
Application.DisplayAlerts = True

Swisse
 
Top