The VBA .FormulaArray seems to have a problem with my range. I've read that it can't handle over 255 characters, but mine is only about 108, but I could be understanding it wrong.
It gives an
Unable to set FormulaArray property of the Range class.
I've tried leaving the formula in the table column and let it automatically populate when the table is filled with the Macro, but the problem is that the Index array table doesn't exist yet before the Macro starts running.
Also tried leaving it as text and then changing the column to "general" but it doesn't work. And I know it will create a problem changing it to an array formula this way as well.
This is the code I'm using:
With wsOutdated.ListObjects("Table_Outdated_Stock_Counts") .ListColumns("Ranging").DataBodyRange.NumberFormat = "General" .ListColumns("Ranging").DataBodyRange.FormulaArray = "=INDEX(Table_DispoData[[Class]],MATCH([@Article]&[@Site],Table_DispoData[Article]&Table_DispoData[Site],0),1)" End With
I need the table column to populate automatically with the array formula. It works for other columns(they are not array formulas though and only need to match a single value).