KG Old Wolf
Board Regular
- Joined
- Sep 20, 2009
- Messages
- 65
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
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