Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 92
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change row' height chacchet New Users to Excel 2 January 7th 07 12:19 AM
How do I change the ROW HEIGHT in one column? Paula Excel Worksheet Functions 2 February 14th 06 02:23 AM
resize row height and column height Tom Setting up and Configuration of Excel 3 April 3rd 05 03:03 PM
Need code to Autofit Row Height on recalculation Bob Tarburton Excel Discussion (Misc queries) 0 March 4th 05 09:31 PM
Change height of row Pam MacT Excel Discussion (Misc queries) 2 January 5th 05 02:54 AM


All times are GMT +1. The time now is 07:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"