Error: Argument size mismatch

TABLE OF CONTENTS

• Overview
• Cause
• Workaround

Overview

Creating a Velixo function which refers to more than one Excel array (using the # syntax) results in a #VALUE! error with the following message:

Text of Message

Argument size mismatch: all arguments containing more than one value are expected to be of the same size 

Cause

When using multiple array references within a single function...

... Excel requires that each array be of the EXACT same size.

If the arrays are not of the same size, this Excel generates this error.

In the above example, there are 149 account codes but only 4 branch codes.

Workaround

When using arrays as cell references, it is usually necessary to only use one array reference within a function.

For example, here we are using a reference to the array of account codes in column C (but only to the individual branch code in row 6):