extract hyperlink with worksheet

R

RRRYBAlex

I have an excel document with a column of hyperlinks. I needed to extract
the text of the hyperlink from that column and did successfully using this
function

rng.Hyperlinks(1).Address

But I also need to extract the worksheet name trailing the hyperlink. What
is the function? Here's what I have

Column B1 says "Grill Shakers"

Hyperlink I've extracted from B1 using rng.Hyperlinks(1).Address is
\\MyServer\Departments\Documentation\Documents\Active Docs\L-110.doc

BUT ACTUAL HYPERLINK in B1 is
\\Slo-hunter\departments\Documentation\Documents\Machine Set-ups\PACKETLINE
Specs\Misc Packet Specs.xls#GS_STEAK_PKT

Thanks in advance!!
 
Top