Hi Gary's Student

what do you mean by "function" a "user defined function" written in VBA or a
formula in a cell in a worksheet? if the later a formula can not affect
another cell only the one it is in ... if it's a vba function then you can
using code along the lines of

Cell(3,3).value = 1

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Gary's Student" wrote in message
...
I am writing a function to calculate the area of a triangle given the
lengths
of the sides. If the inputs are invalid (one side too big), I want the
function to set CELL(3,3) to one. Setting CELL(3,3)=1 in the function
doesn't work. How can I accomplish this?
--
Gary's Student