Save filtered columns as PDFs

[turvak]

Hi,
I got this from another thread but I need to be able to filter a column other than A. When I change the "FilterCol" Dim to C or any other column it returns a 1004 error with a debug focus on line
rngToFilter.AutoFilter Field:=rngToFilter.Column, Criteria1:=FilterCell.Value

I'd appreciate any help on this one.

Please Login or Register  to view this content.

Thanks in advance!

[vba_php]

it worked fine for me with no errors. see images below: