Select sheet in excel

[Siddharth Rout]

I would avoid using .select to select a sheet.

For example if you have the code as below

Sheet(1).Select
Range("A1").Value = "Blah"

You can also write it as

Sheet(1).Range("A1").Value = "Blah"

Need to understand what exactly are you doing...