Can Autofill be used for Hyperlinks

[BushyII]

When I create a hyperlink, to a cell in a distant column, on the sam
row, it works perfectly. However, if I try to then Autofill it down
range of rows the Hyperlinks fail to link to the correct cell address.

The Hyperlink "text" displayed in each cell shows the correc
destination cell address. However, the actual link address is identica
to the very first cell used to create the Autofill.

In other words, if the Hyperlink in cell A1 points to destination cel
AK1
and I autofill from that cell then cell A2...A40 all point to cell AK1
Even though the text displayed from cell A2...A40 has the correc
incremented address, i.e. AK2......AK40
Here's the first hyperlink text: UTM Pipeline!AK6
Here's where the link takes me: UTM Pipeline!AK6

Here's the second hyperlink text: UTM Pipeline!AK7
Here's where the link takes me: UTM Pipeline!AK6

Hope this makes sense

 

[Héctor Miguel]

hi, !

see David McRitchie' page:
- Coding a link address and friendly name using HYPERLINK Worksheet function
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlink

hth,
hector.

__ OP __

 

[Simon Lloyd]

Threads merged

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com