ExcelBanter - CAN A HYPERLINK HAVE AN ABSOLUTE COLUMN & RELATIVE CELL REFERENCE.

I'm not sure if this is what you're after or not, but I'll give it a shot.
I'm assuming you've just got a list of entries in one sheet that are
references to cells on other sheets? Maybe like this:
Sheet2!A1
Sheet2!A2
Sheet2!A3

Here's one way to use a macro to alter the internal hyperlink in such a
list. Start by formatting the column that's going to have the hyperlinks in
it as Text, then type in your addresses. You can type in Sheet2!A1 in a cell
and fill down and it will fill just like I've shown above (but if you set up
hyperlink in the first cell, the hyperlink is unchanged as you fill down -
and I think that's the problem you're encountering?).

Once you've got your entries in the column, and for this example lets
presume they are on Sheet1 and start at C1.

This macro will go down thru the list and make them link to the location
they display:

Sub MakeInternalHyperlinks()
Worksheets("Sheet1").Select
Range("C1").Select
Do Until IsEmpty(ActiveCell)
ActiveSheet.Hyperlinks.Add Anchor:=Selection, _
Address:="", _
SubAddress:=ActiveCell.Text, _
TextToDisplay:=ActiveCell.Text
ActiveCell.Offset(1, 0).Activate
Loop
End Sub

I hope this helps you some, or at least gives you some idea of an approach
to the solution you need.

"june.sidwell" wrote:

is it possible to create a hyperlink to another sheet in a workbook with an
absolute column and a relative row refrence? And can it be copied down a
column without having to edit it for each row?