Re: Sorting a-z | z-a ... removing pop-up "Sort Warning"

Dave --

Hey, thanks. I'm not new to Macro's in Word, but have trouble in excel... I
appreciate the link to try and help me with that.

And, I do see how in Macros and such it could be quite a different
situation, and that makes a lot more sense.

Anyway -- thanks a lot.

"Dave Peterson" wrote:

> The bad thing is lots of people don't notice that the data is messed up until
> after the undo is cleared (like after a save).
>
> You could have a macro that sorts your data based on the activecell. I'd put a
> button on the work*** and assign it this code:
>
> Option Explicit
> Sub testme()
>
> Dim myRng As Range
> Dim myCol As Long
>
> myCol = ActiveCell.Column
>
> With Active***
> Set myRng = .Range(.Cells(1, myCol), _
> .Cells(.Rows.Count, myCol).End(xlUp))
> End With
>
> myRng.Sort key1:=myRng.Cells(1), order1:=xlAscending, header:=xlYes
>
> End Sub
>
> I guessed on the starting row (1) and whether you had headers (I guessed Yes).
> But you could change that to what you want.
>
> If you're new to macros, you may want to read David McRitchie's intro at:
> http://www.mvps.org/dmcritchie/excel/getstarted.htm
>
> MatthewTap wrote:
> >
> > Actually, not really. But, I can understand how many folks would like that
> > -- just a personal preference, I suppose. Not better, not worse, just
> > different. And I suppose I can see how folks could mess up their data with a
> > sort, but usually nothing a good ol' ctrl-z can't fix.
> >
> > But, I do appreciate hearing other people's viewpoints... I'm just big on
> > being able to configure things, and that little window is frustrating to me.
> > [with the disability I have, every move of the mouse, every slight of the
> > hand, anything even that small makes me feel like a ... hmmm, well, I'll save
> > the graphics, and just say it's extremely painful. So, I like to keep my
> > movement to a minimum. And so that's why I was hoping there was a way to 86
> > the pop-up.
> >
> > Well, although not the fix I was hoping for, I appreciate the info -- that
> > does help.
> > Thanks.
> > Matt
> >
> > "Zack Barresse" wrote:
> >
> > > That would be like removing the save changes warning upon closing a workbook
> > > with changes made. Don't you like to be prompted for things like that???
> > >
> > > --
> > > Regards,
> > > Zack Barresse, aka firefytr, (GT = TFS FF Zack)
> > > To email, remove the NO SPAM. Please keep correspondence to the board, as
> > > to benefit others.
> > >
> > >
> > >
> > > "MatthewTap" <MatthewTap@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > news:E2FD4A6C-9CDA-4639-8A78-21F1F2DB1EAE@xxxxxxxxxxxxxxxx
> > > > When I have, for examples, several columns of data, and I highlight one
> > > > column and click to sort that one column, I Always get a pop-up window
> > > > with
> > > > the title 'Sort Warning' that asks me if I really meant to do that, or if
> > > > I
> > > > wanted to include the other text nearby.
> > > >
> > > > Is there any way to remove that pop-up? I've yet to ever use it and I'd
> > > > rather not have to keep closing it if possible.
> > > >
> > > > Any help that you can provide would be great.
> > > >
> > > > Thanks.
> > > > Matt
> > >
> > >
> > >
>
> --
>
> Dave Peterson
>
.