From: RRRYBAlex on 14 May 2010 11:37
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
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
BUT ACTUAL HYPERLINK in B1 is
Specs\Misc Packet Specs.xls#GS_STEAK_PKT
Thanks in advance!!