Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by IThinkIBrokeIt
-
How can I auto-sort in Excel?
forgot to add: Or you could replace Activate() with Calculate()- IThinkIBrokeIt
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How can I auto-sort in Excel?
Just figured this out myself. Record the macro to sort your column. View the code for the desired worksheet. Add: Private Sub Worksheet_Activate() Copy and paste "Your Macro" End Sub Here is my worksheet: Private Sub Worksheet_Activate() Columns("D:O").Select Selection.Sort...- IThinkIBrokeIt
- Post #7
- Forum: VBA Visual Basic for Applications (Microsoft)
