What I am trying to do is find the last cell in column A and then autofilter that cell to the last row in column A based on column B.

I know how to find the last cell in the column using:

VBA Code:

`lrow = Range("B" & Rows.Count).End(xlUp).Row`

And know to use the autofill on a known cell, like below using A2:

VBA Code:

`Range(Range("A2"), Range("A" & lrow)).FillDown`

But how do I use this if A2 is not known?