Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change row' height | New Users to Excel | |||
How do I change the ROW HEIGHT in one column? | Excel Worksheet Functions | |||
resize row height and column height | Setting up and Configuration of Excel | |||
Need code to Autofit Row Height on recalculation | Excel Discussion (Misc queries) | |||
Change height of row | Excel Discussion (Misc queries) |