Obtain Row number from a cell address

  • Hi Guys

    I have a question for you, do you know of a quick way to find the row number given a cell address ?

    For example :

    Foundaddress = c.Address

    The Foundaddress would read something like : $D$5 or $D$121

    What I need is to strip away the $D$ and just leave the row number. I have done a loop like:


    Stripped= Right$(Foundaddress,looper)
    Until Stripped=”$”

    RowAddress= Right$(Foundaddress,looper-1)

    But this is an awful way of doing it,

    Does anyone know a better way, as you can tell my VB Excel is not great 

    Thanks for your time