When I try to sort my data using the
Application.Dialogs(xlDialogSort).Show, I get an alert telling me that
some of my data is number as text and ask me for an option.

How can I programmatically avoid this alert?

Application.DisplayAlerts=False doesn't work