Hello magicians!
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:
And know to use the autofill on a known cell, like below using A2:
But how do I use this if A2 is not known?
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?