Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() s/s is 325501 rows deep and this consists of over 30000 ranges of data. There are formulas at the head of each range in columns K and I. Running down column L is the formula: =K3-I3 The problem is: This last formula runs all down column L and I cannot delete the cells which dont produce a value. The need is for the formula to only appear by the side of the formulas in columns K and I. If anyone can supply code to run, or other help, I would be most grateful. Big thanks. Colwyn. -- colwyn ------------------------------------------------------------------------ colwyn's Profile: http://www.thecodecage.com/forumz/member.php?userid=34 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=52980 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
help with formula for last input in column | Excel Worksheet Functions | |||
Input formula into a column via macro | Excel Programming | |||
Setting of input cells as blue font and formula cells as black fon | Excel Discussion (Misc queries) | |||
Selective Column deletion | Excel Discussion (Misc queries) | |||
More than one cells in row & column input cell | Excel Programming |