Return the row value / position within a range?

Hi

I am having an issue with returning the the row value / position within a range. For example, I have returned the row value for the worksheet:

Please Login or Register  to view this content.

But am failing miserably with getting the value from a range. The range is assigned as below:

Please Login or Register  to view this content.

I then try to return the row value of the active cell within the range (myRange), using the below:

Please Login or Register  to view this content.

The above returns 18, which is the return value for the active cell in the worksheet and not within the range. In the above example the return value for the range should have been 7.

Any help would be much appreciated.

Please use code tags for code snippets... I added them this time for you....

The row position of the active cell relative to myrange is

Please Login or Register  to view this content.