| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need help with hyperlink character limit
Is there a workaround for the 254 character limit in Excel hyperlinks?
If I use the HYPERLINK function with a 500 character URL, (ActiveCell.FormulaR1C1 = "=HYPERLINK(RC[7],RC[1])") all I get is #VALUE, but I have found that if I right-click on a cell and select "Hyperlink" that I can paste the 500 character URL in the address box and the hyperlink will work Is there any way to accomplish this via VBA? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 255 Character Limit | Excel Discussion (Misc queries) | |||
| 255 character limit | Excel Programming | |||
| character limit in hyperlink function | Excel Worksheet Functions | |||
| How can I change 255 character limit in 'hyperlink' function? | Excel Worksheet Functions | |||
| Character Limit | Excel Programming | |||
Threaded Mode
