![]() ![]() ![]() However, from Row 6 – the row from which we start entering data, all the cells are of the same size. This means that – for some of the row headings, some of the cells are merged the heading cells are not all equal in size. The first 5 rows take up the headings – with all the headings formatted the way we require them. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target(1, 1), Range("A:L")) Is Nothing Then Range("A:L").Sort Key1:=Range("B6"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom End IfEnd Sub. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |