How to send arrays to a function

[jmcilhinney]

You could optionally use a sub and ByRef to work directly with your existing array depending on your needs.

There is no need to use ByRef. All arrays are instances of the Array class. Just like all class instances, they are reference type objects. As such, there is no copy made and any changes you make to the one and only Array object are reflected in the caller. Just like all classes, the only reason you would need to use ByRef was if you actually wanted to assign a new object to the parameter inside the method.