1. trishcollins

    Reference Dynamic Table Header Name in Hyperlink

    Okay, I have several tables on several worksheets. I have another table that lists all the formulas from the other tables, so that if I ever get hit by a bus, and someone wipes out the original formula in the other table, they can find it here. I am only using formulas in this spreadsheet, as...
  2. Z

    VBA: Convert Cell Contents into Hyperlink on Cell Change

    Hello, I'm looking for a way to take the contents of a cell and convert it to a custom hyperlink when a cell change is detected. I'm currently using a drop-down list in one column, and another to build the custom URL using that drop-down list selection. Here's what I'm using currently to only...
  3. H

    Excel downloads hyperlink rather than open it

    I have a shared excel workbook within my team and within the workbook are embedded hyperlinks to other shared excel workbooks. For all of the team apart from one, the hyperlink opens the excel workbook, but for one colleague the hyperlink downloads. I have scoured her settings but can't see...
  4. S

    Open file that has A Hash (#) Sign in the File Name

    Hi I just noticed that Excel hyperlink won't be able to open a file that has pound sign (Hash #) in the file name. One solution is to rename those files. However, I have so many files with (#) in their name which not possible solution. Any thought on how to solve this issue?
  5. T

    HyperLinks to folders with the same name as excel cell value

    Hi MrExcel community, this is my first time for posting here. Though I know the topic about matching(look up) and hyperlinks in VBA Excel has been repeated a lot. I have a macros that I would love to ask on how to code which I will explain the criteria of it down below with a picture for better...
  6. J

    Copy and Paste Selected File in a Cell

    I have a piece of code used to on a button to grab an excel file, copy a few bits of data from it, and paste to my current open file and sheet to particular cells. How do I take the path of the selected file and paste it as a link in my currently open workbook and sheet in cell A35. I just...
  7. D

    VBA code to create a hyperlink from files in a folder and assign to a cell with a similar name

    I have the following code that creates hyperlinks from all pdfs contained in a folder and listed in column N. Sub extractfiles_hyperlink() Dim xFSO As Object Dim xFolder As Object Dim xFile As Object Dim xFiDialog As FileDialog Dim xPath As String Dim i As Integer...
  8. H

    How to use hyperlink automatically ?

    I have a list of members in column A with their website URL (just url) listed in column B, I copy the URL of each member from the column B into hyperlink in column A, and this process takes a long time. I need a macro code to do it for all the members.
  9. A

    School fee challan print by clicking roll no.

    Dear All, I have an excel file which contains students sheet with month name and school fee challans sheet. A) When I click on the roll no. then print of challans on other sheet should be sent to printer with this student record: 1) Roll no. here as challan no there 2) student name and...
  10. J

    Image Hyperlink Subaddress - Variable Cell Reference (VBA)

    Ok, all, first time posting on any forum. Just been sitting in the back, reading and learning. But now I'm stuck and decided to ask for help. I need to assign a created image with a hyperlink to a hidden sheet, using a variable address based on the value of a cell. EV36 would be the location of...
  11. M

    Other version of Hyperlink

    Hi. In advance, sorry for my english. I want to link value to other excel when i click cell i dont want to go other sheet for explain, i want it show when i aproach to cell. Please look at images
  12. S

    Hyperlink > go to certain worksheet based on cell value

    Hi all, I am still learning with excel and have been rattling my brain over the past few days of how to get this to work! So here we go.... In worksheet "Log", cells C2, C3, C4 will have values inserted from a userform with numbers like 732, 733, 744 etc and these cells will be hyperlinked. I...
  13. N

    VBA: Auto Insert Hyperlinked Photos and Resize

    I found a script for inserting hyperlinked photos that works well with one column. However, I would like to know how to insert for multiple columns like I, J, K, L, M, N. Each column will have several rows of hyperlinks. Here is the code I found that works well for single column. Just need to...
  14. H

    Sendkeys methods to work for range

    Hi! This is my first thread on this forum, hope you understand me and help :) I am working with excel for my personal project. I would to make a macro_button which changes formulas/text for hyperlink. I have tried many options with sendkeys in macro but still have same problem. There are my...
  15. 2

    Turn last non-blank cell address formula into a Hyperlink

    Formula returns address of last non-blank cell in column A: ="A"&MATCH(2,1/(A:A<>""),1) e.g.: A1000 Trying to turn it into a Hyperlink with: =HYPERLINK("A"&MATCH(2,1/(A:A<>""),1)) results in below error, when clicking on it. How to turn last non-blank cell address formula into a Hyperlink...
  16. E

    Hyperlink using a column as reference.

    Hi, My data looks something like this: A B C 1 Name: Date Of Birth: Reference: 2 SMITH, John 12/03/1988 K3472 3 JONES, Kayla 27/04/1962 K7895 4 RUSS, Tim 08/07/2022 I want the names (A2:A4) to be hyperlinks using the data from Column C. The link to the website...
  17. M

    Add Hyperlink to Excel VBA Email Body

    Hello, I have the below code in Excel that generates emails. I'd like to add a hyperlink to a website in the middle of the email body but can't work out how? Does anyone know? Sub SendEmails() Dim Emails, Subject, FName, SName, Attachment, Body As String Dim i As Long Dim OutApp As Object...
  18. H

    How to extract Url and make it clickable automatically?

    Hello, I have a set of websites listed in an excel sheet, I tried to extract hyperlink using VBA code (I found it online), but I find out that they not clickable. Could you edit it or give another trick to fix this problem, please? Sub ExtractHL() Dim HL As Hyperlink For Each HL In...
  19. H

    How stop mobile version when clicking on hyperlink in Excel?

    Hello, I have a set of facebook profiles listed in my Excel spreadsheet, the thing is that when I click on any profile, it opens up with both mobile version and the web version. I need to stop the mobile version so that when I click on the profile it only open the web version. P.S : I tried...
  20. M

    Hyperlinks in data table

    Hello, I have two sheets, first of them has a data table with the income of a list of 14 companies during 2018 and 2019. The other sheet I've a data table with a list of these companies and next to the name an hiperlink. When it's selected, it transports you to the cell located in the row of...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back