How to get the relative cell number within a range?

Hello,

What is your definition of " easily " ...???

To count the total number of cells in your range : =ROWS(C4:H9)*COLUMNS(C4:H9)

But, for the relative cell number, you will need VBA ... which might go against your definition of " easily " ...

Hi,

Maybe this will help

Option Explicit
Sub ActiveCellArea()
    Dim pd, x, n&
    Set pd = [C4:H9]
    For Each x In pd
        n = n + 1
        If ActiveCell.Address = x.Address Then
            MsgBox n
            Exit For
        End If
    Next
End Sub

Hello again,

Agree with pike

Although it seems to me ... UDF would be more in line with initial request ...

Function relative(rng As Range, c As Range)
' UDF to get Relative Cell Number in Range
Dim r As Range, n As Long
    For Each r In rng
        n = n + 1
        If c.Address = r.Address Then relative = n
    Next r
End Function

Hope this will help

Very true,, i'm a bit rusty

Quote from pike

Very true,, i'm a bit rusty

Let me doubt it ... !!!

The rabbit is well known for his ability to run very fast ...

Thanks for your Thanks