255 character limit in HYPERLINKfunction

[smithrd6]

I am unable to create hyperlinks with characters longer than 255. Is there a workaround?

thanks

 

[jasonb75]

Maybe a shorter url?

http://tinyurl.com/ for example

 

[smithrd6]

not an option......url is established by the source

 

[jasonb75]

Have a look at

http://www.technicallychris.com/200...in-word-and-excel-longer-than-256-characters/

can you use that?

 

[smithrd6]

works but is still limited. By creating a macro, this worked:

Sub MacLink()
'
' MacLink Macro
Range("A1").Select
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"Enter your hyperlink here", TextToDisplay:="Whatever Name You Want"


End Sub

I am using another auto_open mac and running it on the task scheduler to do those tasks while away.

work......

thanks