Copy/Paste using hyperlinks
 

I am trying to create a workbook with the following:
A list of approx 50 hyperlinks on one sheet, to go to a named range on a
second sheet and then to copy paste that selection to a third sheet.
Can anyone help

Copy/Paste using hyperlinks
 

for each hlnk in ActiveSheet.Hyperlinks
now parse out the information you want to get the location, then copy
that information. Or use the followhyperlink method.

Next


"Michael" wrote in message
...
I am trying to create a workbook with the following:
A list of approx 50 hyperlinks on one sheet, to go to a named range on a
second sheet and then to copy paste that selection to a third sheet.
Can anyone help