Just use the control or shift key to select the sheets desired. then put 100
in a1. Excel will put it in all

--
Don Guillett
SalesAid Software

"Pat" wrote in message
...
Hi,
If Sheet1!A1 = 100
then Sheet2!A1 = 100, Sheet3!A1 = 100, Sheet4!A1 = 100

I do not want to use a formula preferring to execute via a commandbutton.

Any ideas?