I tried to create a simple macro to create 3D arrays, but I failed.
Function JTMSplit2(expression1, delimiter1 , optional limit1)
JTMSplit2 = Split(expression1, delimiter1, limit1)
End Function
in the image, I tried to use JTMSplit2 2 times at the same array to split a string to 2D array, but failed.
test01 jtmsplit.ods (15.4 KB)
With dimensional arrays, I mean:
0D : single cell
1D : a row or a column array
2D : an array with size multiple row and multiple columns
3D : 3rd dimension should be new sheets inside same workbook.
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 12; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-PE (es_PE); UI: en-US
Calc: threaded