AutoFilter issues (2)

[KG Old Wolf]

First Question:

All, I need to enter a macro area and be able to force the autofilter off.
Using
Selection.AutoFilter
only toggles me back and forth - I need to be sure it is off

Second Question:

I need to be able to select a field that will vary in location within the spreadsheet. Using the following will not work - any suggestions?

Selection.AutoFilter Field:=(FinalColumn - 3), Criteria1:="="


Thanks,
Ken