what I have:

I have a workbook that has to 2 sheets. (Sheet1 and Sheet2).

Sheet1(ColumnA) has the column i need to hyperlink to cells(ColumnB) on sheet2.

What i need :

create a routine that will insert a hyperlink on Sheet1 relating to Sheet2.

example:

on Sheet1 have Cell A2 HYPERLINK TO B5 on Sheet2.

A3 will hyperlink to B6

A4 will hyperlink to B7   etc….

but hard code the range…so i can change the range if needed.

This formula sub seems to only do a single insert  ?

Sub HyperlinkAnotherSheet()

Worksheets(“Sheet1”).Select Range(“B5”).Select ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:=“”, SubAddress:=“‘Sheet2’!A1”

End Sub

Thanks

fordraiders

​what I have:I have a workbook that has to 2 sheets. (Sheet1 and Sheet2).Sheet1(ColumnA) has the column i need to hyperlink to cells(ColumnB) on sheet2. What i need :create a routine that will insert a hyperlink on Sheet1 relating to Sheet2. example:on Sheet1 have Cell A2 HYPERLINK TO B5 on Sheet2.A3 will hyperlink to B6A4 will hyperlink to B7   etc…. but hard code the range…so i can change the range if needed.  This formula sub seems to only do a single insert  ?Sub HyperlinkAnotherSheet()Worksheets(“Sheet1”).Select Range(“B5″).Select ActiveCell.Hyperlinks.Add Anchor:=Selection, Address:=””, SubAddress:=”‘Sheet2’!A1″End Sub Thanksfordraiders  Read More

​