would refer to ONLY the workbook of that name.
Refers to the Workboook which is active (the one you see)
Is a Index number being in the order that the open Workbooks were opened.
Always refers to the Workbook that houses the code.
Refers to a Worksheet by it's sheet tab name. One of the most popular ways but also the worst and unsafest way.
As the name suggests
Is the Index number going from left to rigt
Nearly the same a Worksheets but could also be used for another type of sheet, eg Chart Sheet
The one you haven't mentioned is the most important one and that is
This is a sheets CodeName and is the safest and best way to refer to a sheet (it cannot be changed) Unless deleted ) You can see a Sheets CodeName in the Project Explorer (it's the one NOT in brackets).
OzGrid Business Applications
Microsoft Excel/VBA Training
[ This Message was edited by: Dave Hawley on 2002-03-12 03:34 ]