Hi everyone!

I am trying to record my macro as the below

[ActiveWindow.SmallScroll Down:=6
ActiveSheet.Range("$A$16:$E$27").AutoFilter Field:=5, Criteria1:="dencel"
Range("A16:E22").Select
Selection.Copy]

I want that my Range("A16:E22") to be dynamic after filter because I keep adding data?

Please any help would really be appreciated.

Thanks in advance,

Rev12