Get relative row from range.find

[Vladislav]

Good morning, I have a number of named columns in a table. When I do a find on the key column, I want to be able to return the row relative to the range being searched instead of the row relative to the worksheet A1 cell.

i.e. I don't want to set up an offset... here's what I mean:

'What I do now:
lRowOffset = rKey(1,1).row -1
lRelativeRow = rKey.find(sKey).Row - lRowOffset

'What I'd like to do (where RelativeRow is just a wish method)
lRelativeRow = rKey.find(sKey).RelativeRow

Is there some method to do this?
cheers, Vlad