I have composes an excel function called StaticMap which appends text to it and it should return more than 255 chars, but when I run it it always stop at around 252.
The call is wrapped around inside a hyperlink function like this:
Public Function StaticMap(data as String) As String
StaticMap = "http://maps.google.com/maps/api/staticmap?size=512x512&maptype=roadmap
StaticMap = StaticMap & "&markers=color:blue|label
:A|" & a
StaticMap = StaticMap & "&markers=color:green|labe
l:B|" & b
StaticMap = StaticMap & "&markers=color:red|label:
C|" & c
StaticMap = StaticMap & "&sensor=false"
While tracing the StaticMap variable it stops at 252 chars.
Is this a limitation of VBA or Excel?
How to allocate more memory to a string object?