1) Manually select the range A1:A10
The Selection is A1:A10
2) Start pressing the Enter key on your keyboard - notice that one cell that turns white and moves down? that's the Active cell.
So to summarize - in code you could do this:
The same logic can be applied with sheets:
Hope that explains a little better
Sheets(Array("Sheet1", "Sheet2", "Sheet3")).Select
Generally speaking, there is very rarely any need to "Select" anything in VBA, but that will come naturally as you learn more of the language and how to use objects and their properties directly. Until then - there's always OzGrid! :D