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.
Code:Dim var As Variant var = Cells(1).CurrentRegion.Value Range("E1").Resize(UBound(var), UBound(var, 2)) = var




Reply With Quote

Bookmarks