Excel VBA main classes

The below table contains links to topics regarding the use of the main classes in Excel: Range, Worksheet and Workbook. The image at the bottom shows how you get access to all code fragments for all classes in Excel - with Range » Set » Range » SpecialCells » Comments as an example showing code to be inserted and available description and F1 hyperlink to online help on this subject.

Object model tree

The Object model tree in other languages: Spanish, German, Portuguese and French.

Range	Worksheet	Workbook
Set range variable	Declare and Set worksheet	Create a new workbook
Different ways to loop through a range	Create a new worksheet	Open a workbook
SpecialCells such as blank, lastcell and more	Used range in worksheet	Set Workbook variable
Working with range cells	Protect worksheet	Close workbook
Select and loop columns	Delete worksheet	Protect workbook
Hide rows	Hide worksheet	Test if there is an open workbook with certain name
Hide columns	Activate worksheet (versus Select)
Clear Content, Format, Comments and more	Test if a sheet exists with name