Thread: 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:

  Dim ActiveRowCount As Integer

       ActiveRowCount = ActiveCell.Row 'In this example we will say it returns 18

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

 Set myRange = ActiveCell.CurrentRegion
        RowCount = myRange.Rows.Count ' In this example we say it returns 15

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

myRangeActiveRowCount = myRange.Application.ActiveCell.Row

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

myRow = ActiveCell.Row - myRange.Row + 1