Hi All
I have just today subscribed to the forum, I am very rusty on Excel having not used it for quite sometime I did an intermediate course in Excel XP and gained a certificate but that is not helping me much with my Excel 2007. I will be enrolling a new course later but as it is getting very close to tax deadline I would greatly appreciate any help in my exercise. I have in column A of my worksheet a list of consecutive invoice numbers starting at GLA000249 going to GLA000323 I want to be able to use a macro or a formula to link those invoice numbers to the actual invoices in a folder in "my documents\my excel files\GLA000249.xlsx etc etc" I have tried the macro below but receive error message "error opening file"
![]()
Dim cCell As Range For Each cCell In selection.Cells If cCell.Hyperlinks.Count = 0 Then On Error Resume Next ActiveSheet.Hyperlinks.Add _ Anchor:=cCell, _ Address:=cCell.Value, _ TextToDisplay:=cCell.Value End If Next cCell End Sub
Bookmarks