Collection of Sheet Names

Through this Program we can collect sheet names which exists in our current work book

For better under standing i am providing four types of loops

1)For - - - Next Loop:

We need to identify total number of sheets that the excel workbook consists of

Sheets.count is the property to retrieve total count of sheets

2)For Each - - - Next Loop:

It Loop through each element entire group of elements

In this example element = sheet., for each sheet in group of sheets

3)Do While Loop:

Body exectutes As long as condition is true

4)Do Until Loop:

Body exectutes As long as condition is FALSE

Download The Workbook