![]() The macro assumes that you want to sort on the data in column A and that there is a header in cell A1. Private Sub Worksheet_Change(ByVal Target As Range) (You can view the code window by right-clicking the worksheet tab and choosing View Code from the resulting Context menu.) The following is an example of one such simple macro: ![]() You can, for instance, add a macro to the code for a worksheet that is triggered when something in the worksheet changes. The only way that this can be done is by using a macro that is triggered whenever something new is entered in the worksheet. Pat thinks it would be great, for instance, that when she adds a new name to a list of names that the names are automatically sorted to always be in order. Pat wonders if there is a way to automatically sort every time she adds new data to a worksheet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |