How do I turn off sort warning?

[Guest]

When I want to sort just one column of data (but has data next to it) MS
Excel asks if I want to expand the range or continue with current range. Can
I turn this warning sign off?

 

[Chip Pearson]

Not in the normal UI, you can't turn off the warning. In code,
you can use Application.DisplayAlerts = False to supress the
warning.

Application.DisplayAlerts = False
' sort code
Application.DisplayAlerts = True


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




message
news:[email protected]...

 

[Guest]

Thank you. I'll have our IT people help me figure out how to do it.

Again, much thanks!

 

[Lady Layla]

Chip just explained to you how to do it.


: Thank you. I'll have our IT people help me figure out how to do it.
:
: Again, much thanks!
:
: "marknorris95" wrote:
:
: > When I want to sort just one column of data (but has data next to it) MS
: > Excel asks if I want to expand the range or continue with current range.
Can
: > I turn this warning sign off?