Kevin,

Second time's the charm :). Glad I could help.

Doug

"Kevin McCann" wrote in message
oups.com...
That worked perfectly! Thank you very much for the help!

On Oct 17, 12:40 am, "Doug Glancy"
wrote:
Kevin,

Well, my first reply was useless I think. Perhaps a macro like this?:

Sub AddHyperlinks()
Dim i As Long

For i = 1 To 1000
Worksheets("Sheet1").Hyperlinks.Add _
Anchor:=Worksheets("Sheet1").Range("A" & i), _
Address:="", _
SubAddress:="Sheet2!A" & i, _
TextToDisplay:="Sheet2!A" & i
Next i
End Sub

hth,

Doug

"Doug Glancy" wrote in message

...

Kevin,

If you use the Hyperlink function, you can then use the fill handle.
In
Sheet1A1 put this formula:

=HYPERLINK(Sheet2!A1)

and then copy down. Using this function is said to be more robust than
regular hyperlinks anyways.

hth,

Doug

"Kevin McCann" wrote in message
roups.com...
I would like to use something like the fill handle in Excel to help
fill in a spreadsheet with hyperlinks. I want to link:

Sheet1 A1 to Sheet2 A1
Sheet1 A2 to Sheet2 A2
Sheet1 A3 to Sheet2 A3

...and so on. So far I have not had much luck. I can get it done one
cell at a time, but I would like to do about 1000 of them and there is
no way I am going to spend that much time on this. Does anyone know of
a way to do this automatically? Thanks in advance!

-Kevin