tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi everyone,
I have a number of filters within a range all written like the one below
the problem i have is it not hiding the filter droopdowns for columns that dont have a filter in them
is ther a bit of code or way i can tell it to not show any dropdowns for the range?
in the example above only fields 1 and 6 have the dropdowns hidden which is not what i want
please help if you can
Tony
I have a number of filters within a range all written like the one below
the problem i have is it not hiding the filter droopdowns for columns that dont have a filter in them
is ther a bit of code or way i can tell it to not show any dropdowns for the range?
VBA Code:
Sheets("Proposals Dashboard").Range("$AC$65:$AQ$" & LRfilter1).AutoFilter Field:=6, Criteria1:=Focus, VisibleDropDown:=False
Sheets("Proposals Dashboard").Range("$AC$65:$AQ$" & LRfilter1).AutoFilter Field:=1, Criteria1:=Sold, VisibleDropDown:=False
in the example above only fields 1 and 6 have the dropdowns hidden which is not what i want
please help if you can
Tony