Unmerge vertically merged header cells to allow adding filter on rowī. '* return column's index from column lettersįunction GetColumnIndex(sColLetter As String) As Integerĭim iMax As Integer: iMax = Len(sColLetter)Ī.
'Merge unmerged cells to restore previous state Selection.AutoFilter Field:=GetColumnIndex("H"), VisibleDropDown:=False Selection.AutoFilter Field:=GetColumnIndex("G"), VisibleDropDown:=False Selection.AutoFilter Field:=GetColumnIndex("C"), VisibleDropDown:=False 'Remove (or Hide) filter combobox for some columns 'Unmerge merged cells to allow adding filter NLast = Range("A" & Rows.Count).End(xlUp).Row '* PUBLIC method to call to define CUSTOM AutoFilter I want to add some filters on explicit columns but not on row 1 only on row 2 as you can see in following screen's capture. I know that I'm on SuperUser and not on StackOverflow, but the solution to this problem can be found in using VBA code on Excel 2016.
0 kommentar(er)
