Timeline for Excel's Dynamic Array Functions...In VBA (No Win 32)
Current License: CC BY-SA 4.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 19, 2019 at 13:09 | vote | accept | rickmanalexander | ||
| Sep 10, 2019 at 11:21 | review | Suggested edits | |||
| Sep 10, 2019 at 12:47 | |||||
| Aug 23, 2019 at 2:01 | answer | added | TinMan | timeline score: 3 | |
| Aug 20, 2019 at 23:41 | history | edited | rickmanalexander |
edited tags
|
|
| Aug 20, 2019 at 19:31 | comment | added | Greedo |
Minor thing but all the areas where you concatenate strings could be neatened up a fair bit with this lightweight printf function - so "ArrayToSheet1D(" & strRngAddressToRight & "," & True & ")" becomes printf("ArrayToSheet1D({0},TRUE)", strRngAddressToRight) or strRangeBegin & CStr(lngStartRowBelow) & ":" & strRangeBegin & CStr(lngEndRowBelow) to printf("{0}{1}:{0}{2}", strRangeBegin, lngStartRowBelow, lngEndRowBelow)
|
|
| Aug 20, 2019 at 14:48 | history | edited | rickmanalexander | CC BY-SA 4.0 |
edited body
|
| Aug 20, 2019 at 14:42 | comment | added | rickmanalexander | @JonPeltier Because the array is zero-based, range.resize is cutting off the last element. See my edit for details. | |
| Aug 20, 2019 at 14:41 | history | edited | rickmanalexander | CC BY-SA 4.0 |
added 1283 characters in body
|
| Aug 20, 2019 at 12:41 | comment | added | Jon Peltier |
Why does GetDynamicArray1D skip the last element of the array?
|
|
| Aug 20, 2019 at 0:00 | history | tweeted | twitter.com/StackCodeReview/status/1163601551748939776 | ||
| Aug 19, 2019 at 23:57 | comment | added | rickmanalexander | @MathieuGuindon If this can be object oriented, while at the same time implementing more error checking procedures, looking at formula precedent and dependent relationships, etc., some really cool stuff could be done with it. | |
| Aug 19, 2019 at 23:42 | comment | added | Mathieu Guindon | I can't wait to play with it, wondering if e.g. INDEX could wrap SORTVALUES =) | |
| Aug 19, 2019 at 23:35 | comment | added | rickmanalexander | Sortvalues can be fed a range, which is converted into an array, sorted, and then sent back to the sheet in the format needed. GetDynamicArray1d can be fed values in the formula arguments (not range) and it will also return an array to the sheet; it’s more so for proof of concept really. | |
| Aug 19, 2019 at 23:12 | comment | added | Mathieu Guindon | So, IIUC, the functions return actual arrays that can be fed to array-accepting functions, correct? | |
| Aug 19, 2019 at 22:34 | comment | added | Mathieu Guindon |
While outputting a #SPILL string looks like the thing, I would recommend outputting an actual existing/supported Error type (e.g. CVErr(xlErrValue)), so that native functions like IsError still work correctly.
|
|
| Aug 19, 2019 at 22:28 | history | asked | rickmanalexander | CC BY-SA 4.0 |