Hyperlink Error Linking Worksheets

So what I’m doing is hyperlinking my summary page items with each worksheet in the workbook.  I’m getting an error in my code on the last line posted:

    WBSITEMNUMBER = “=IF(‘” & WBSNum & “‘!T$44<>0,'” & WBSNum & “‘!N$8,””””)”
    Worksheets(“SUMMARY”).Cells(lastRow, 1).Select
    Selection.NumberFormat = “00.000”
    Selection.Formula = WBSITEMNUMBER
    Dim iSheet As Worksheet
    Set iSheet = Worksheets(“SUMMARY”)
    Dim iSheetString As Integer, wSheetString As Integer
    iSheetString = iSheet.Cells(lastRow, 1).Value
    iSheet.Hyperlinks.Add iSheet.Cells(lastRow, 1), “”, WBSNum & “!N8”, iSheetString, iSheetString


The error that I’m getting is Run-time error ‘5’: Invalid procedure call or argument.

I did a watch on the whole line and the code that’s giving me the error.

The error seems to be here iSheet.Hyperlinks.Add .  The error for this says Expression not defined in context.

Can anyone help me.


By: Darlene Sippio

40 thoughts on “Hyperlink Error Linking Worksheets

  1. Acheter Oxandrolone

    Good day very nice blog!! Man .. Beautiful .. Amazing .. I’ll bookmark your website and take the feeds also…I’m happy to search out numerous useful info right here within the publish, we’d like develop extra techniques in this regard, thank you for sharing.

  2. ig

    Just wish to say your article is as astounding. The clearness in your post is simply cool and i can assume you are an expert
    on this subject. Well with your permission allow me to grab your feed to keep updated with forthcoming
    post. Thanks a million and please continue the gratifying work.

  3. USMLE Step 2 CS Exam preparation

    Today, I went to the beach with my children. I found a sea shell and gave it to my 4 year old daughter and said “You can hear the ocean if you put this to your ear.” She put the shell to her ear and screamed. There was a hermit crab inside and it pinched her ear. She never wants to go back! LoL I know this is entirely off topic but I had to tell someone!

  4. Wolfgang Kulterer

    you’re really a good webmaster. The site loading speed is amazing. It seems that you are doing any unique trick. In addition, The contents are masterwork. you have done a excellent job on this topic!

  5. more info

    There are definitely a variety of details like that to take into consideration. That may be a great point to deliver up. I provide the thoughts above as common inspiration but clearly there are questions like the one you deliver up where the most important thing shall be working in sincere good faith. I don?t know if greatest practices have emerged around things like that, however I’m sure that your job is clearly recognized as a good game. Each girls and boys really feel the impression of just a moment’s pleasure, for the remainder of their lives.

  6. Clifton Smyre

    Can I just say what a relief to find someone who actually knows what theyre talking about on the internet. You definitely know how to bring an issue to light and make it important. More people need to read this and understand this side of the story. I cant believe youre not more popular because you definitely have the gift.

  7. BuyHerbs

    Very nice post. I simply stumbled upon your weblog and wanted to say that I’ve truly loved browsing your blog posts. In any case I’ll be subscribing to your feed and I am hoping you write once more soon!

  8. Darci Rodan

    Hiya, I am really glad I’ve found this information. Today bloggers publish just about gossips and internet and this is actually frustrating. A good blog with interesting content, that’s what I need. Thanks for keeping this website, I’ll be visiting it. Do you do newsletters? Can not find it.

  9. sling tv asksylphoflight

    An outstanding share! I have just forwarded this onto
    a coworker who had been doing a little homework on this.

    And he actually ordered me lunch simply because I discovered it for him…

    lol. So allow me to reword this…. Thank YOU for the
    meal!! But yeah, thanks for spending the time to discuss this topic here on your blog.

  10. sling tv

    I loved as much as you will receive carried out right here.
    The sketch is attractive, your authored subject matter stylish.

    nonetheless, you command get got an impatience
    over that you wish be delivering the following. unwell unquestionably come more formerly again as exactly
    the same nearly very often inside case you shield this hike.

  11. ps4 games

    I’m really inspired along with your writing abilities as smartly as
    with the structure to your blog. Is that this a paid theme or did you modify it yourself?
    Anyway keep up the excellent quality writing,
    it’s uncommon to look a great weblog like this one nowadays..

  12. tinyurl.com

    Wow, superb blog format! How long have you ever been blogging
    for? you make blogging glance easy. The whole glance
    of your web site is great, as well as the content!

Comments are closed.