Error message is says 'Private Const' is not allowed in Subs or Functions, so I assume only modules. This is in userform. It wouldn't let me dimension the array using just the variable so I tried to set it as a constant...
Code:
Private Const Columns = NumberOfCollumns()
Dim ColumnTitles(Columns) As Variant
Dim HUGEarray(Columns + 1, 100000) As Variant