Instead of Index I should have said Contents

for example, under conceptual topics:

Understanding Objects, Properties, Methods, and Events

--
Regards,
Tom Ogilvy

"Tom Ogilvy" wrote in message
...
There are also variables, functions, subroutines (both also refered to as
procedures).

within variables there are many types, but of interest would be Array's
and
user defined types.

If you go to the VBE and choose help, then look at the index, it basically
lays all this stuff out for you.

--
Regards,
Tom Ogilvy




"dee" wrote in message
...
Hi again,

I'm keeping you busy today! Thank you so much.

OK, I'm following what you explained. So, that means that the main
pieces,
if you will, of VBA code would be:
Objects
Properties
Methods
Arguments
Constants? (Still unsure of how these are defined)

Are there any other standard "pieces" that I should be researching?

Thank you so very much.


"Tom Ogilvy" wrote:


ActiveCell is a property of Range object and Select is a method

No. ActiveCell is a Range Object. It is maintained internally by
Excel
to
point to the cell which currently has the focus or would have the
focus
if
that window were activated. Select is a method. One would usually
use
ActiveCell.Select to reduce a multi-cell selection to a single cell or
in
Excel 97 to overcome a bug in the ActiveX controls

Application.CutCopyMode=False means The CutCopyMode property of the
Excel
object is False (property)

If a range has been copied to the clipboard (the standard, not the
office
clipboard), this clears the clipboard and removes any copy marquee.



Selection.Copy means Copy (method) the selection (range property)
Yes


PasteSpecial is a method applied to the range object (selection
property)
Yes

Paste: xlPasteValues, etc. are all properties, but of what? The
Selection?
No, they are arguments to the pastespecial method. If you manually do
a
copy then do Edit=PasteSpecial, you are confronted with a dialog with
many
possible selections. These arguments represent those selection
possibilities.

--
Regards,
Tom Ogilvy


"dee" wrote in message
...
I'm struggling with these. IN the following code:
ActiveCell.Select
Application.CutCopyMode = False
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False

Am I correct is assuming:

ActiveCell is a property of Range object and Select is a method

Application.CutCopyMode=False means The CutCopyMode property of the
Excel
object is False (property)

Selection.Copy means Copy (method) the selection (range property)

PasteSpecial is a method applied to the range object (selection
property)

Paste: xlPasteValues, etc. are all properties, but of what? The
Selection
?

I have searched quite extensively, but to find easy to understand,
plain
English definitions of objects, methods, properties, constants, etc.
difficult to find.
--
Thanks!

Dee