hi
no. a formula can only return values to the cell in which it resides. it can
not put values in other cells nor can it perform actions. only macro code can
do this.
sorry.
regards
FSt1

"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