VBA how to change Autofilter's criterial to the value of a cell instead of a fixed value?

[nevers711]

Hello everyone,

I would like to let Macro to filter a certain table's column for me and the criterial should be a value of a cell (B1) instead of a fix value">=1/1/2022". How can I do this? Here is my code. Thank you if anybody can shed some light

    ActiveSheet.Range("$A$1:$B$100").AutoFilter Field:=4, Criteria1:= _
        ">=1/1/2022"

 

[Z51]

Maybe try:

ActiveSheet.Range("$A$1:$B$100").AutoFilter Field:=4, Criteria1:=">=" & ActiveSheet.Range("B1").Value

 

[nevers711]

Thank you! It works perfectly