Skip to content

Instantly share code, notes, and snippets.

@seamusabshere
Created November 2, 2024 14:40
Show Gist options
  • Save seamusabshere/f9dfbe976d4d8ffb82e9591c20fe5bfe to your computer and use it in GitHub Desktop.
Save seamusabshere/f9dfbe976d4d8ffb82e9591c20fe5bfe to your computer and use it in GitHub Desktop.
1-click Excel autofilter and freeze panes
Sub autofilter_split()
Rows("1:1").Select
' Turn on Autofilter
Selection.AutoFilter
Rows("2:2").Select
' Freeze Panes
ActiveWindow.FreezePanes = True
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment