I have a command button on Sheet1 which I would like to use to clear
contents in a column range on Sheet1, Sheet2, and Sheet3. How do I do
this without Activating Sheet2 and Sheet3?


Code in the Sheet1 Module

Private Sub cmdClearCol5_Click()
ActiveSheet.Range("E11:E1000").ClearContents
[sheet2 code??]
[sheet3 code??]
End Sub

Thanks
Ruan