LinkBack URL
About LinkBacks
Hello, the macro below worked on roughly 65000 cells before it started giving me the error pictured below. Now any macro I run gives me this error. Any idea why?
excel object error.JPG
Please Login or Register to view this content.
Thanks!
Hello, the macro below worked on roughly 65000 cells before it started giving me the error pictured below. Now any macro I run gives me this error. Any idea why?
excel object error.JPGPlease Login or Register to view this content.
Thanks!
Hello DC,
In Excel 2000 - 2003, the hyperlinks are stored in a 64KB storage area. So, the length of the links will effect the exact number that can be stored. Not sure about Excel 2007 and up.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Leith, I am using excel 2007 so perhaps the storage area is the same. I am trying to create just a hair over 100k links. I will see if I can find anything. Thanks for the suggestion!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks