Hello, I've run into some trouble again. I have hyperlinks that point to
data from the same folders in different spreadsheets. The row order of the
spreadsheets will be rearranged by other users which will make the hyperlinks
redirrect the user to the wrong entry. I am trying to create a sub that will
repair the links and although my first idea did work, it took nearly a minute
per spreadsheet. I beleive I've found a way to write a sub that is much
faster but the big hurdle I face is extracting the row number from a
hyperlink on another spreadsheet. My Hyperlink formual looks like this (
=HYPERLINK("#'Check Sheet'!A60:R60", "Name Insured") ). With my spreadsheets
nearing a thousand rows I was wondering if there is a simple way I can just
have non-numeric characters dropped. Does anyone have any ideas. Anything
would be greatly appreciated.

Thanks,
Abode