PLEASE HELP: How to make column more dynamic

[Mangolili]

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, niot only the entire A column , but the any column? Please help, many thanks in advance.

 

[iliace]

Intersect(Sheets("Value").Range("A:A"), Sheets("Value").UsedRange)

 

[Mangolili]

Thank you so much iliace, will try it out.