+ Reply to Thread
Results 1 to 5 of 5

creating hyperlinks fails after row 65530 with run time error 1004

  1. 02-09-2017, 03:11 AM #1
    dschmitt
    dschmitt is offline
    Valued Forum Contributor
    Join Date
    02-21-2010
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2007
    Posts
    502

    creating hyperlinks fails after row 65530 with run time error 1004

    the following code crashes at row 65530. Is there a workaround for this limitation?

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-09-2017, 03:53 AM #2
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: creating hyperlinks fails after row 65530 with run time error 1004

    Hi,

    I believe that is simply a limit of Excel on how many hyperlinks you can have. If you use HYPERLINK() formulas it should avoid the issue.
    Don
    Please remember to mark your thread 'Solved' when appropriate.
    Reply With QuoteRegister To Reply
  3. 02-09-2017, 04:13 AM #3
    dschmitt
    dschmitt is offline
    Valued Forum Contributor
    Join Date
    02-21-2010
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2007
    Posts
    502

    Re: creating hyperlinks fails after row 65530 with run time error 1004

    I am afraid you are right.
    If I use 2 hyperlink creating loops then the crash occurs when the sum of hyperlinks from both loops reaches 65530.
    Reply With QuoteRegister To Reply
  4. 02-09-2017, 04:20 AM #4
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: creating hyperlinks fails after row 65530 with run time error 1004

    As I thought, it is a hard limit- https://support.office.com/en-us/art...AAA=Excel_2007
    Reply With QuoteRegister To Reply
  5. 02-09-2017, 05:00 AM #5
    dschmitt
    dschmitt is offline
    Valued Forum Contributor
    Join Date
    02-21-2010
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2007
    Posts
    502

    Re: creating hyperlinks fails after row 65530 with run time error 1004

    thanks for clarifying it.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA run-time error 1004 with hyperlinks.add
    By bfs3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2014, 03:23 PM
  2. Run time error 1004 While creating charts. Please help. Its Urgent!!!
    By raghav1234 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-04-2014, 07:47 AM
  3. [SOLVED] Run time error 1004 when creating named range
    By csh8428 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2012, 08:33 AM
  4. Code fails with error 1004
    By cdjones in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-22-2010, 06:27 PM
  5. Macro fails at pasting (Run-time error '1004' Paste method fail)
    By SergioS in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-09-2010, 02:17 PM
  6. Range.Validation Add Fails with 1004 error
    By Hila in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-15-2009, 11:11 AM
  7. Creating xls file via xml getting Run-time error '1004'
    By ydnam in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-17-2006, 10:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1