"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Sandy posted two sets of code. The first was event code, the second was a
macro
that would be run by hitting a button or Alt + F8 and Run.

I think he meant for both to be Event code

Thank sfor pointing that out Gord - I never even noticed that I copied the
wrong code the second time.

--


Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Sandy posted two sets of code. The first was event code, the second was a
macro
that would be run by hitting a button or Alt + F8 and Run.

I think he meant for both to be Event code

Event code goes into the sheet module.

The macro goes into a general module

A caveat should be mentioned if using the Event code

Autosort leaves no room for making mistakes in data entry.

If you misspell a word and hit enter that misspelled word is sorted with
the
rest of the data.

Could make it hard to find later.


Gord Dibben MS Excel MVP


On Wed, 21 Mar 2007 14:20:36 -0000, "Sandy Mann"

wrote:

Forgot to say to get into the sheet module right-click on the sheet tab
and
select "View Code"