If you want a complete list of all the objects, methods and properties you can
use in VBA, go to help, Microsoft Excel Visual Basic Reference, Microsoft
Excel Object Model.

Under Objects all the objects are listed
Under Methods all the methods are listed
Under Properties all the properties are listed.

There is also a lot of information under Programming Concepts.

I think this resource would answer  most of your questions, but please feel
free to post back if there is anything you still have problems with.