AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Install vba in excel 20162/9/2023 ![]() ![]() Sub Macro2()ĪctiveWorkbook.Worksheets("RSVP Report").ĪctiveWorkbook.Worksheets("RSVP Report"). Key:=Range( _ See code that works and was recorded on my machine. := xlSortOnValues, Query := xlAscending, := xlSortNormalĪctiveSheet.("RSVP Report").SetFirstPriority.Add := Range("B2:B23"), Value _ := xlSortOnValues, Query := xlDescending, := xlSortNormalĪctiveSheet.("RSVP Report").SetFirstPriority.Add := Range("C2:C23"), Value _ Sub Macro1()ĪctiveSheet.("RSVP Report").SetFirstPriority.ĪctiveSheet.("RSVP Report").SetFirstPriority.Add := Range("A2:A23"), Value _ Note the missing ".Sort" and double period in between ("RSVP Report") and SetFirstPriority. Sort method is missing from that machine. I recorded a Sort macro using the Developer Toolbar. ![]() On that machine, I get a Runtime 9 or Runtime 438 error. I have VBA code that sorts a specific sheet. ![]() There seems to be something wrong with Excel as installed on one of the computers in our office. ![]()
0 Comments
Read More
Leave a Reply. |