Functions called from cells on worksheets can only return values to that cell
(with very minor exceptions).

You may want to look at worksheet/workbook/application events that will touch
other cells.

default105 wrote:

with excel 2000, can a formula place a value in another cell or can this only
be done with vba or a macro
--
Pete Blackburn - words to live by:
"Don''t ever let somebody tell you. You can''t do something.You got a
dream,You gotta protect it." Edited Quote from the Pursuit Of Happiness

--

Dave Peterson