Since my workbook is formula driven based on one cell on one worksheet and
the value I need to change resides on another worksheet, what event would be
better to use. This one cell changes the data on 12 worksheets.
--
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








"Don Guillett" wrote:

A formula may not do that but you can use =a1 to get the data in a1.
However, you may use a worksheet_change event macro in the sheet module that
when a1 is changed will do whatever is desired to the other cell.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"default105" wrote in message
...
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