Handling string in an array of length greater then 255 in excel

[Rick Rothstein]

Is the array created by passing values directly from a range? Or is it created from the keys of a dictionary object?

I made a few cells of text having texts of length around 3000 to 4000 characters, and the following code work just fine each time.

    Dim var As Variant
    
    var = Cells(1).CurrentRegion.Value
    Range("E1").Resize(UBound(var), UBound(var, 2)) = var

I did roughly the same thing you did, but used shorter text in the cells that I created the array from and then assigned a longer piece of text to one of the array elements afterward. I too ran into size limit as to how long a text string I could assign to the array element before writing it back to the worksheet failed, but it was not 255 characters... strangely, it turned out to be 911 characters (I could assign 910 characaters successfully, but adding one more character to it crashed with the 1004 error). If it helps any in trying to figure out what is going on here, I am using XL2003 on a Win7 (SP1) system.