Code to change column height of arrays?
 

Hi,

Today, I have several columns of array formulas on sheet2, 3 and 4 to
run match (and more) on sheet1.
To cover 800 possible used rows in sheet1, the arrays are 800 rows
high. It make it slow.

I'll like to turn this into a dynamic row height approach instead.
When you add a row or just put in some figures, in a cell of a new
row, on sheet1 each column in each sheet2,3 and 4 should dynamically
get the array extended with as many rows as there are in sheet one.
Probably check column height in sheet1 with worksheet_change event!

In this way, it will be just a six row array on each sheet if there is
only six rows used in sheet1.

I guess you had to delete the array and recreate it one row higher
with code?

There are several different formulas in diferent column - maybe you
also need to store the array formula in a "helper sheet"? And pick it
up with the code on demand. A bit risky otherwise to delete the
formula compleatly without having a backup in a cell somewere...

What would be my best approach to create this kind of routines?

Regards
Tskogstrom