Extract cell reference from hyperlink created by VBA

I have a macro (thank you watersev!) that finds a cell reference in my worksheet based on a search value and returns a clickable hyperlink to send me to that cell in my worksheet.
What I want is that in my "Start" sheet on cells D9 downwards I want it to look into the hyperlink that is created in C9 downwards, and if that cell reference hyperlinked is less than 190, return the word Premium, and if not then return AP/RP. As per my example in the attached.

The macro that fires when you hit the search button currently does the following:

Please Login or Register  to view this content.

is this not possible?

sorry to be a pain - but noone?