none
cell reference in web address hyperlink?? RRS feed

  • Question

  • Hi-
    Still new, so this may be a simple fix...

    I have a list I repopulate daily, from which I export multiple targeted lists. Without going into too much detail, is it possible to enter the contents of a cell into a web address hyperlink??

    I am trying to create a link to search on the site based on what is in a cell

    ex.http://mywebsite.com/region/?gf_search=midwest      <--current search

        http://mywebsite.com/region/?gf_search=(cell reference) <--what I am trying to do  thanks!

    Thursday, April 9, 2015 6:25 PM

All replies

  • Re:  using cell reference

    Try...
     Dim strText as String
     strText = Range("A1").Text
     http://mywebsite.com/region/?gf_search=strText
    '---
    Jim Cone
    Portland, Oregon USA
    https://goo.gl/IUQUN2 (Dropbox)
    (free & commercial excel add-ins & workbooks)

    • Edited by James Cone Sunday, October 30, 2016 7:41 PM
    Friday, April 10, 2015 1:13 PM