Concepts – Containers or Collections


nA Group of Similar Objects Share Common Properties, Methods and Events
nSuch as Workbooks, Worksheets, etc.
nWorksheets is a collection of all the Worksheet objects in the specified or active workbook.
nWorksheets(1) refers to the 1st worksheet of current active workbook.
nWorksheets (“mooring”) refers to the worksheet named  “mooring”.

Popular posts from this blog

50 Excel VBA Oral Interview Questions