Thanks for the info, but here is a stupid question when I put this
formula in the unused data cell, It still shows the formulas, example:
a-1 and b-1 are is where the data will be entered so a1+b1 should be
empty and the formulas start in c1.

a-1 b-1 c-1 d-1 e-1
a1+b1 b1-a1 b1/a1

I want to hide the results of the formulas until data is put into a-1
b-1


--
Donald
------------------------------------------------------------------------
Donald's Profile: http://www.excelforum.com/member.php...o&userid=15171
View this thread: http://www.excelforum.com/showthread...hreadid=493310