Auto Update sizing for array table

[LordByron]

Hi All!

I have a table of data - T1132 : AME1182

Some of the cells are blank / unused.

In this specific example only range T1132 : GX1182 has values.

My questions is this; I would like to create an array formula that automatically resizes based on the cells that contain a value. For instance, in the next use of the sheet, the range could be T1132 : AAA1182 and I would manually have to update the array formula; I would like to know if there is a macro / vba fix to this?

The array formula used so far is;

{=mmult(transpose($T$1132:$G$X1182),$T$1132:$G$X1182))/(count($s1019:$s$1070)-1)}

Thank you in advance!

[LordByron]

Any suggestions?