VBA-Better-Array
VBA-Better-Array copied to clipboard
Senipah
An array class for VBA providing features found in more modern languages
Hi Senipah! As usual, I was digging into the sorting methods and the strengths/weaknesses of these algorithms. As you may know, VBA CSV interface uses, even these days, the fast...
```VBA Sub Currently() Dim ws As Worksheet Set ws = Sheet1 ws.UsedRange.Clear Dim multiArea As Range Set multiArea = ws.Range("A1:B2, A3, B5:D5") multiArea.Value2 = 1 Dim ba As New BetterArray...
hi,please,i want to copyfromdictionary,just like copyfromrange. what I have tried : ```vb Dim arrResult As New BetterArray arrResult.Items = dict.keys arrResult.Transpose arrResult.Push dict.Items ``` But it didn't work. I expected...
The title says it all. One of the array elements created is `252,002128362656` (in the Immediate Window), so in English it would be `252.002128362656`. In `StringBuilder` `Fragment` (at least for...
The title says it all. In the Immediate Window I get the following values for `Expected` ``` Sub-Saharan Africa,Chad,Office Supplies,Online,L,1/27/2011,"292,494,523.00",12/02/2011,"4,484.00",651.21,524.96,"2,920,025.64","2,353,920.64","566,105.00" Europe,Latvia,Beverages,Online,C,12/28/2015,"361,825,549.00",1/23/2016,"1,075.00",47.45,31.79,"51,008.75","34,174.25","16,834.50" ``` and for `Actual` ``` Sub-Saharan Africa,Chad,Office Supplies,Online,L,1.27.2011,"292.494.523,00",12.02.2011,"4.484,00","651,21","524,96","2.920.025,64","2.353.920,64","566.105,00" Europe,Latvia,Beverages,Online,C,12.28.2015,"361.825.549,00",1.23.2016,"1.075,00","47,45","31,79","51.008,75","34.174,25","16.834,50"...
I started reading the docs and found some typos in it. To appreciate your work this is my (first) feedback/thank you. Feel free to cherry-pick.
**Describe the bug** ``` Dim arr As BetterArray Set arr = New BetterArray arr.LowerBound = 1 arr.Items = Array(1, 2, 3) Debug.Print arr.Slice(4)(1) ``` output 3 **Expected behavior** arr.Slice(4) should...
**Describe the bug** It seems if the length of the table is less or equal than 3, the `Splice` method erases the last value even when asking not to. **To...
Has there been any thought to adding iterable support for Better Array? You can do that by adding a NewEnum property like so: ``` Public Property Get NewEnum() As IUnknown...
