Ref: Getting Started with VBA in Excel 2010

Introduction

Collections

Many objects come in both singular and plural versions—Workbook and Workbooks, Worksheet and Worksheets, and so on. The plural versions are called collections. Collection objects are used to perform an action on multiple items in the collection.

Excel Object Model Reference Link 

which is part of the Excel 2007 Developer Reference on the Microsoft Developer Network (MSDN).

 Object-Oriented Programming in Visual Basic

 Excel VBA Custom Classes & Objects, Class Modules, Custom Events  ดีมากๆ

Read this

Class Module Introduction

Array Formula

 

Leave a Reply