Copy / Paste / IE

[NX555V]

Hello,

Thanks in advance.

I have a list of URLs in column A. I want to be able to double click on the cell in column A where the url is and have it either:

1) copy it so I can paste it into a browser url box

or and better, but not absolutely necessary

2) copy it and then open a browser and paste it into the url window. I would need to be able to do this in IE/Firefox

Thanks!

 

[Yard]

Simple attempt at 1)

Right click worksheet tab, View Code, paste this:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)

If Target.Count = 1 Then
    Target.Copy
    Cancel = True
End If

End Sub

 

[westconn1]

well i might be missing something here, but if i type a url into a cell, when i click it, it opens a default browser window to the url

excel 2000