Jun 8, 2016 · This function returns an array regardless of the size of the range. Ranges will return an array unless the range is only 1 cell and then it returns a single value instead.

I would like to write a function to return an array of integers so I can index them, but I am not aware of the syntax for VBA. Here is the pseudo code: function getStats() as integer dim return...

Here is why: The code that calls the function already knows that it wants to use Title and Checked, so nothing is lost when it gets an array of ContentControl instances instead of a …

Apr 17, 2017 · 54 This seems unnecessary since the Array() function documentation clearly states that the function returns a Variant type, but VBA is a strange place. If you declare an …

I did a test with an array of size 2000. The worst case scenario for looping through the array would be looking for the last item (at index 2000). After 5000 calls to both the function and looping, …

I'm looking for a decent sort implementation for arrays in VBA. A Quicksort would be preferred. Or any other sort algorithm other than bubble or merge would suffice. Please note that this is to work

I'm also applying the UNIQUE function to remove any multiple blank ("") results. This works perfectly if I manually type the formula into Excel, however in using VBA to add the formula, …

May 5, 2017 · 2 So I want to make a basic function that takes an average of values that I highlight in Excel. I am well aware there is already a built-in function in Excel for this but I am trying to …

I've edited my answer slightly to reflect the array request. Inside the question it gets ambiguous and the user states the desire to do what clicking the Remove Duplicates button does but in …

VBA question. I'm using it to make Solidworks macros, but that's not important. Can someone explain the syntax to pass an array (1-Dimensional of type Double, with length of three) to a …