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

Don't use the dialog.

use the sort method in code and set the parameters you want.


Turn on the macro recorder and do the sort manually. Then turn off the
macro recorder and look at the recorded code. If you run it, the dialog
(nor the prompt) will be shown.
--
Regards,
Tom Ogilvy


wrote in message
oups.com...
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