Posted 10 May 2018, 9:06 am EST
How do I cancel or reset the Auto Filter auto sort combined in ExtendedSelect mode on a spread column?
I’ve tried:
mycols.ResetSortIndicator()
mycols.AllowAutoSort = False
mycols.AllowAutoFilter = False
They all error:
Current column(s) belong to a sorted range. Cannot change AllowSort to false