LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default how to input formula into selective cells in column ??


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
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
help with formula for last input in column mag Excel Worksheet Functions 7 January 13th 12 04:06 PM
Input formula into a column via macro franciz Excel Programming 10 June 3rd 08 08:03 AM
Setting of input cells as blue font and formula cells as black fon Sunnyskies Excel Discussion (Misc queries) 2 May 14th 07 05:27 PM
Selective Column deletion mattrane Excel Discussion (Misc queries) 4 December 25th 05 02:01 AM
More than one cells in row & column input cell SAMI GAD Excel Programming 0 September 15th 03 08:20 AM


All times are GMT +1. The time now is 09:21 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"