Object variable or With block variable not set (Error 91)

by

As I wrote in my comment, the solution to your problem is to write the following:

Set hyperLinkText = hprlink.Range

Set is needed because TextRange is a class, so hyperLinkText is an object; as such, if you want to assign it, you need to make it point to the actual object that you need.

More Related Contents:

  1. How do I get values from a hidden worksheet using VBA [closed]
  2. How to copy cells that contain certain text to another worksheet [closed]
  3. VBA Macro for copying and pasting columns on same excel sheet
  4. Excel VBA, code to count the # of filled cells, then find highest and 2nd highest and subtract the corresponding column #’s [closed]
  5. How to add default signature in Outlook
  6. Levenshtein Distance in VBA [closed]
  7. How to convert VBA script to Google Apps Script automatically?
  8. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  9. Assign event handlers to controls on user form created dynamically in VBA
  10. Programmatic Access To Visual Basic Project Is Not Trusted
  11. Can I make this macro more efficient or faster?
  12. Conditional Formatting using Excel VBA code
  13. Controlling IE11 “Do you want to Open/Save” dialogue window buttons in VBA
  14. How to get the background color from a Conditional Formatting in Excel using VBA
  15. VBA Excel Populate ListBox with multiple columns
  16. VBA Integer Overflow at 70,000
  17. How to count up text of a different font colour in excel
  18. VBA Macro to compare all cells of two Excel files
  19. Automate saveas dialogue for IE9 (vba)
  20. Sending HTTP requests with VBA from Word
  21. What does ReDim Preserve do?
  22. How to highlight a cell using the hex color value within the cell?
  23. How do I open an outlook .msg file from my harddrive that is NOT in outlook?
  24. Convert RTF (Rich Text Format) code into plain text in Excel
  25. lastrow and excel table.
  26. Exporting MS Access Forms and Class / Modules Recursively to text files?
  27. Repeating Microsoft Word VBA until no search results found
  28. Text To Clipboard in VBA Windows 10 Issue
  29. Excel VBA using FileSystemObject to list file last date modified
  30. How to have vba execute every 10 minutes?

Leave a Comment