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.      <--current search reference) <--what I am trying to do  thanks!

    Thursday, April 9, 2015 6:25 PM

All replies

  • Re:  using cell reference

     Dim strText as String
     strText = Range("A1").Text
    Jim Cone
    Portland, Oregon USA (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