Border line on last filtered row

[Av8tordude]

how can I put a line under the last filtered row. I tried the code below, but it places a line under every row. I just want a line under the last filtered row.

Range("A7:S" & lRow).LineStyle = xlContinuous

 

[Fluff]

Duplicate to: Goto last filtered row

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.