Ars Technica

Excel, VBA, Autofilter, and Arrays

Not open for further replies.
CCM

Check if a value exists in an array VBA

To check if a value exists in an array, we can loop through its elements. However there is another solution! You can use the INDEX () function, native to Excel and in the case of two-dimensional ...
TheServerSide

Java array size, length and loop examples

Community driven content discussing all aspects of software development from DevOps to design patterns. Here are the most important concepts developers must know when they size Java arrays and deal ...
Ars Technica

Passing arrays from Excel VBA to a C++ dll

OK, I'm having a problem making a function call from VBA to C++. I'm not even sure if it is possible to do this.I have a c++ function whose header looks like this: int32 myDllFunction ( int32* ...