PDA

View Full Version : VBA code to filter a specific column



Jimbo2112
12-29-2020, 08:25 AM
I have a large workbook that routinely pull a sheet from and email. I have a code to email but I need to set up a filter on a specific column before emailing. This column will change each week BUT will always be the 9th non-hidden column. Is there a way I create a line of code that will filter this column?