Tags Tags

Hyperlink - How to copy

July 08th, 2008 - 03:06 pm ET by Xena | Report spam
Help Create a new topic
I am trying to copy a hyper link down 300 rows in a document. I was hoping
as I drag down the cell that it is hyperlinked to would change just as if I
were copying. How can I change the designated cell in the hyperlink without
having to enter it 300 times.

Thanks
Xena
email Follow the discussionReplies 1 replyReplies Make a reply

Similar topics

Display all similar topics

Replies

#1 Bill Manville
July 08th, 2008 - 04:59 pm ET | Report spam
How did you create the hyperlink?
The only way it would adjust would be if you used the HYPERLINK
worksheet function, e.g.
=HYPERLINK(Sheet2!A1, "Go to " & Range("A1").Address)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup
email Follow the discussion Replies Reply to this message
Help Create a new topicReplies Make a reply
Search Make your own search