79166322

Date: 2024-11-07 11:58:27
Score: 1.5
Natty:
Report link

I don't know what was causing the issue but I've found a workaround using table sort methods. The last line of the code above has been replaced with:

With wl.ListObjects("waiting_list").Sort
    .SortFields.Add Key:=Range("A3", "A" & w_last_row), Order:=xlAscending
    .Header = xlYes
    .Apply
End With
Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Detra