macros affecting different worksheets
 

I have created a spreadsheet with a macro that clears certain cells. I need
it to clear cells on a seperate worksheet too. Is this possible, and if so,
how do I do it. Please bare in mind that I am not totally confident with
macros and this is my first attempt.

Thanks

Read about the Personal.xls file he
http://www.vbaexpress.com/forum/arti...catid=2&page=3
************
Anne Troy
www.OfficeArticles.com

"CJW" wrote in message
...
I have created a spreadsheet with a macro that clears certain cells. I need
it to clear cells on a seperate worksheet too. Is this possible, and if
so,
how do I do it. Please bare in mind that I am not totally confident with
macros and this is my first attempt.

Thanks