Good Morning,
I have recorded a macro to remove the filters from a selected row and then re-apply to a selected column.
It's the first time I've had a go recording a macro and it can take an age to complete.
Could anyone offer something that might work a bit quicker.
This is what I have done.
![]()
Sub Filter() ' ' Filter Macro ' ' Keyboard Shortcut: Ctrl+m ' Range("A4:V4").Select Selection.AutoFilter Range("A4:V4").Select Selection.AutoFilter ActiveSheet.Range("$A$4:$V$20019").AutoFilter Field:=19, Criteria1:="No" End Sub
If possible i'd also like it to run when you open the workbook and with a keyboard shortcut of [Ctrl] + m
Thank you for any help you can provide.
Tom
Bookmarks