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