Add Hyperlinks

[jscranton]

Where ws is a worksheet and LR is the last row, I am trying to add a hyperlink to another location (asheet.cel.Address). The text to display is an array of data that I am trying to find.

When I run this, however, I get invalid call or argument error. Any ideas?

         With ws                        
                         .Hyperlinks.Add Anchor:=.Range("A" & LR), _
                        Address:="", SubAddress:="'" & aSheet.Name & "'!" & cel.Address, _
                        TextToDisplay:=p(x)
                    End With

 

[jscranton]

Nevermind. I am an idiot. This works fine. My array p() was the problem.