+ Reply to Thread
Results 1 to 3 of 3

Segregating Hyperlink & HyperText - Please Help

Hybrid View

  1. 03-12-2009, 08:51 AM #1
    ramki
    ramki is offline
    Registered User
    Join Date
    10-13-2006
    Posts
    60

    Segregating Hyperlink & HyperText - Please Help

    I have a spreadsheet with a Hyper Link and Title of the hyperlink in column "A" and I want to show the actual URL code in Column B by Referencing the data in Column A. Please Help
    Reply With QuoteRegister To Reply
  2. 03-12-2009, 09:05 AM #2
    Shijesh Kumar
    Shijesh Kumar is offline
    Valued Forum Contributor Shijesh Kumar's Avatar
    Join Date
    05-26-2008
    Location
    Bangalore / India
    MS-Off Ver
    2000
    Posts
    717

    Re: Segregating Hyperlink & HyperText - Please Help

    U have to create a UDF

    Public Function getURL(ByRef Cell As Range) As String

   getURL = Cell.Hyperlinks.Item(1).Address

End Function
    usage

    =getURL(A1)

    will show the actual webaddress
    Shijesh Kumar
    http://shijesh.wordpress.com/
    Reply With QuoteRegister To Reply
  3. 03-13-2009, 08:31 AM #3
    ramki
    ramki is offline
    Registered User
    Join Date
    10-13-2006
    Posts
    60

    Re: Segregating Hyperlink & HyperText - Please Help

    Thanks Srijesh. It is working perfectly
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1