subaddress

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...

Hello and just a thanks to everyone in advance :):). I am using Excel 2010, old but it suits my needs ;) I need someones assistance on how to open a Hyperlink with a subaddress. See below and please advise: (01) In the active workbook, I am able to create a hyperlink with a sub address (see...

I am trying to modify an existing hyperlink from a VBA macro The existing link is in cell B1 (B1 through H1 are merged to fomB1 if that makes a difference) of worksheet("TestSheet") I want to change the existing subaddress from whatever it is to "UI!A", and the TextToDisplay from whatever it...

Good afternoon everyone. This is one of those 'summary sheet with hyperlinks' questions. I have everything working great, but my hyperlinks all link to !A1 and I would like to change that to the matching cell on the destination sheet. The code below is part of a loop which takes some of the...

I am putting together a macro that 1) Creates a new tab as a copy of a tab named 'Template' 2) Queries the user to enter a name for the new tab 3) Inserts a new line to a table within a worksheet in a tab named 'Summary' 4) Enters the new tab name into the cell in the first column of that new...

Hi there, I am trying to create a hyperlink to each line of a list of titles that are produced through a While loop. The below code works fine, but does not allow for the Anchor and SubAddress to be adjusted with each iteration of the loop. ActiveSheet.Hyperlinks.Add Anchor:=Cells(3, 2)...