I'm trying to figure out a simple problem. I've looked around th
forum, but can't seem to find exactly what I'm looking for. I want t
take a hyperlink and cut off everything up until the last slash an
assign the remaining string to a variable.

I want to take this string:

Code
-------------------
http://www.something.com/xNet/MainSi...4&PgCxtDir=Dow
-------------------

...and end up with this string:

Code
-------------------
Profile.aspx?LID=12345678&RecentlyViewed=true&Item Index=14&PgCxtDir=Dow
-------------------


the closest I got was getting everything before the final slash to b
assigned to a variable. I know this is a simple problem, but
appreciate any help as I'm very new to VBA. Thanks in advance

--
neverend
-----------------------------------------------------------------------
neverends's Profile: http://www.excelforum.com/member.php...fo&userid=3504
View this thread: http://www.excelforum.com/showthread.php?threadid=54955