Anthony's VBA Forum Index Anthony's VBA Forum
Where the knowledge is shared
Menu
 Anthony's VBA Forum IndexHome Page
 Anthony's VBA Forum IndexForum Index
FAQFAQ
MemberlistMemberlist
UsergroupsUsergroups
RegisterRegister
ProfileProfile
Log in to check your private messagesMessages
Log inLogin/Out

Quick Search

Advanced Search

Links
Consulting
Products

Who's Online
[ Administrator ]
[ Moderator ]


Help with Hyperlinks

 
Post new topic   Reply to topic     Anthony's VBA Forum Index -> General Excel VBA
View previous topic :: View next topic  
Author Message
Bushy



Joined: 20 Mar 2009
Posts: 1

PostPosted: Fri Mar 20, 2009 3:59 pm    Post subject: Help with Hyperlinks Reply with quote

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

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

In other words, if the Hyperlink in cell A1 points to destination cell 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 correct 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.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic     Anthony's VBA Forum Index -> General Excel VBA All times are GMT - 4 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group