I was looking through the contents of the VBAX Code Library (neat stuff!), and I came across two procedures which I didn't understand the purpose of. The first is:
[VBA]Sub Sheet_Activate_1()
Sheets(1).Activate
[A1].Activate
End Sub[/VBA]
What does this Sub do for you? It appears to activate (select?) the first worksheet in the workbook, then (if I understand the shorthand) select cell "A1". Why would one need a procedure to do that?? Is Activate in this context equivalent to Select?