Sub ReadAvailableFilters()
' count the number of available filters from "Value" sheet
' NOTE: "-1" is needed because the first row is the title of the column,
' not a filter itself
numFilters = Application.WorksheetFunction.CountA(Sheets("Value").Range("A:A")) - 1
How do I change A:A to something more dynamic, not only the entire column of A, but count the available filters from any column?
Please help, many thanks in advance.
' count the number of available filters from "Value" sheet
' NOTE: "-1" is needed because the first row is the title of the column,
' not a filter itself
numFilters = Application.WorksheetFunction.CountA(Sheets("Value").Range("A:A")) - 1
How do I change A:A to something more dynamic, not only the entire column of A, but count the available filters from any column?
Please help, many thanks in advance.
Last edited:
