Getting around the Max String size in a vba function?
I may have missed something here, but why can’t you just declare your string with the desired size? For example, in my VBA code I often use something like: Dim AString As String * 1024 which provides for a 1k string. Obviously, you can use whatever declaration you like within the larger limits of Excel … Read more