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:


    Looper=1


    Do
    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


    Adrian