VB Code to sort Names Alphabettically

Hi Riz,

Not sure how your code was actually working considering there is no data in column A

Anyway, this should do the job:

Please Login or Register  to view this content.

Regards,

Robert

Hi Trebor:

Very smart code, works great.
One thing needs to added.
If i add or change any name in First name column (Column B) then pop the message to let the sude know that you are adding another employee, do you want to delete the corresponding data in that row....
The reason for this is that i want to overwrite the employee who is no more active so if I change the first name for new employee then want to make sure that the related information for inactive old employee clears out so that i can add new info.

Please let me know if you have any questions.
Thanks.

Riz

You can use this - the only slight downside is that it will always ask the question even if the name is edited but not changed (this would be quite rare in any case I would envisage):

Please Login or Register  to view this content.

Regards,

Robert

You're welcome.

Thanks for marking the thread as solved and adding to my rep

Hi Riz,

It's working for me

One possible explanation could be if the macro fails midway during its execution for whatever reason, the EnableEvents option might be set to False hence stopping all macros from working. Assuming this is the problem, try the following where both screen updating and events are both set back to true if an error occurs:

Please Login or Register  to view this content.

The other thing to bear in mind is that the above code are event macros assigned only to Sheet1. They will therefore not execute on any other tab.

Regards,

Robert