"Worksheets("Sheet1").Select"will simply activate  to that sheet, then what is
the use of "Worksheets("Sheet1").activate"
I think we need to work around more what do u feel Dian ?
Somewhere, I found that it's useful when you will make your excel sheet  as
ADD-Ins....As there is not sheet to activated B'coz it's hidden..
Once I revel this topic more I'l post..