Thread: Need help with hyperlink character limit
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Gary is offline
external usenet poster
  
Posts: 273
Default 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?
Reply With QuoteReply With Quote