Get the last row of a spilled range

[Skybluekid]

I have a spilled range, which is generated from a Filter Function. I would like to get the last row of that range using VBA. I have used Sheet7.Range("K3").End(xlDown).Row, but it only brings back the the top row where the formula is.

Thanks in Advance

 

[JEC]

That should work though, do you have an example?

 

[RoryA]

Something like:

with Sheet7.Range("K3").spillingtorange
    msgbox .row + .rows.count - 1
end with

 

[Skybluekid]

Something like:

with Sheet7.Range("K3").spillingtorange
    msgbox .row + .rows.count - 1
end with

Hi @RoryA
Sorry I did not make myslef clear in my orignal post, I wanted the row count in a variable. So I got this
'Get Range of Activity Table
ARow = Sheet7.Range("K3").SpillingToRange.Row and it comes up with

 

[RoryA]

If the formula is not currently spilling to other cells, you will get that error. You can test for that first:

With sheet7.Range("K3")
if .hasspill then
with .spillingtorange
arow = .row + .rows.count - 1
end with
else
arow = 3
end if

 

[Skybluekid]

Thank you @RoryA