Try error-trapping along these lines ..

Instead of say, in D2, copied down: =B2*5-C2
Make it in D2 as: =IF(OR(B2="",C2=""),"",B2*5-C2)
Copy down

D2 (col D) will then remain/appear "blank" until values are input into both
precedents B2 and C2 (cols B and C)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"franbarb" wrote:

I wrote a very simple program showing my fuel oil consumption. It seems
to work ok. my problem is hiding cells that have not in use yet. Is it
possible to post my file? I know someone out there will laugh and do it
very simply.
thanks for any help.

Each day I enter the date, the amount used and It shows how much is
remaing in the 'tank' and how much i used each day. my problem, the
sheet shows negative number where I haven't entered any data yet..
franbarb


--
franbarb
------------------------------------------------------------------------
franbarb's Profile: http://www.excelforum.com/member.php...o&userid=35807
View this thread: http://www.excelforum.com/showthread...hreadid=555813