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