M
merry_fay
Hiya,
I want to set an autofilter in my macro, but the autofilter field isn't
necessarily always going to be the same number. It will always have the same
column header though.
Is there a way to change the number to the column header, or make it filter
on the 'active column'?
Selection.AutoFilter Field:=14,
Thanks
merry_fay
I want to set an autofilter in my macro, but the autofilter field isn't
necessarily always going to be the same number. It will always have the same
column header though.
Is there a way to change the number to the column header, or make it filter
on the 'active column'?
Selection.AutoFilter Field:=14,
Thanks
merry_fay