https://bugs.documentfoundation.org/show_bug.cgi?id=144924
--- Comment #11 from Andreas Heinisch <andreas.heini...@yahoo.de> --- I see your problem now. You may change it to: Dim aaVariant(UBound(aaDesMisusOut)) As Variant For r = 0 To UBound(aaVariant) aaVariant(r) = Split(aaDesMisusOut(r), "::") Next Sure this code does not run anymore like it run for 20 years, but there are other bugs which arise from this behaviour of the split function which we addressed with this change. Unfortunately, there are still a lot of inconveniences in LOs macros and we tried to fix some of them in the last two years with the new macro team, and some of them break existing macros due to loose restrictions of the functions. I hope this workaround is fine. However, I will try some workarounds using the split function itself and report back. -- You are receiving this mail because: You are the assignee for the bug.