What you need to know

I saw a few holes in the plan. I knew that I had to determine the following:

■ How to identify the active workbook

■ How to count the sheets in the active workbook

■ How to get a list of the sheet names

■ How to rearrange the sheets according to the sorted list

Tip When you lack critical information about specific methods or properties, you can consult this book or the VBA Help system. You may eventually discover what you need to know. Your best bet, however, is to turn on the macro recorder and examine the code that it generates when you perform some relevant actions. You will almost always get some clues as to how to proceed.

0 0

Post a comment