thank you , very helpful
-----Original Message-----
object.object.method, or
object.object.method argument, or
object.object.property = value, or
variable = object.object.property

Workbooks(3).Worksheets.Add
Workbooks(3).Worksheets.Add Worksheets(1)
Workbooks(which workbook).Worksheets(which
worksheet).Name = "SomeName"
variable = Workbooks(which workbook).Worksheets(which
worksheet).Name

"methods" do things. Add, Save, Copy are methods
"properties" are characteristics. Color. Name, Visible
are properties
you assign values to properties or read the properties
into variables
methods sometimes return a value. Add often usually
return a reference to
the thing added.
objects sometimes "raise events" - event handlers
contain can code that
executes when the event "happens"

When you see Applies To in a property listing in Excel
help, this is a list
of the objects that have that property. It also means
that you need one of
these object in order to use that property. Workbooks
have Names. Worksheets
have Names, etc.

Visible Property
See Also Applies To Example

When you see Applies To in a method listing in Excel
help, this is a list of
the objects that have that method. It also means that
you need one of these
object in order to use that method. The Workbooks
collection can Add members
to itself. The Worksheets collection can Add members to
itself, etc.

Add Method
See Also Applies To Example


"mike" wrote in message
...
how do you read statements?? i know you are to read
right
to left.
Is it 'property.method.value'
is that how it is set up..what follows the period and
so
on?
THANKS!

where can i go to read up on the breaking down of the
statements to understand what it is asking?


.