Help UsingScript functions and finding complete Excel Add-in documentation
Hi all, very new to OS and am having some issues using the XFGetCellUsingScript() function and UsingScript functions generally. Specifically, the GetCellUsingScript function can't seem to handle more than 2 POV changes to an original POV but using the XFGetCellUsingScriptEx() which has 16 POV arguments doesn't seem to work at all, it just returns #VALUEs. The XFGetCell function is comically long and inflexible (doesn't work with any arrays or text joining functions that I've tried) so [...]UsingScript[...] functions seem like a much cleaner way to go but I'm having serious difficulty learning to use any of them because the documentation for the add-in functions isn't very good. The descriptions of the functions under the Retrieve Functions section is not complete and it doesn't define the function arguments or give examples. Any thoughts, best practices or helpful blog posts you could share would be much appreciated.