VBA Right/Find Function

[Gregorys05]

Hi Guy's
I am trying to get som VBA code to get a cell address for example

$A$1 i just want the row value of 1 now i know i can use
Len(Cell.address,4,1) or Right(Cell.address,1)

But I want to make this full proof so that if the cell ref is:

$AB$1 or $A$1000000 it will still return the row value,

Is there a way to do this in VBA at all??

Thanks

 

[Lewiy]

You can just use the .Row property, so if your cell variable is "Cell" then you'd just need:

Cell.Row

 

[Gregorys05]

Thank you, something so simple.

Knowledge is power.
And i have neither