Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Chisisi Massri   on Nov 24 In MS Office Category.

  
Question Answered By: Wallace Kelly   on Nov 24

Try this: In each of your sort  macros, turn AutoFilter mode off before sorting,
then turn it back on afterward. Don't know why, but when I experimented with it,
that worked.

Sub SortMacro1()
'Turn AutoFilter mode off
ActiveSheet.AutoFilterMode = False
'Your Sort routine
Range("A6:I15").Sort Key1:=Range("B6"), Order1:=xlAscending, Header:=xlGuess
'Go to A6 and turn AutoFilter mode back on
Range("A6").Select
Selection.AutoFilter
End Sub

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on VBA AutoFilter question Or get search suggestion and latest updates.


Tagged: