Worksheets and Sheets are object collections that are identical with a few small exceptions. Their task is to manipulate objects within a worksheet, and which one we’ll use is often a matter of personal choice. In the text that follows you will become familiar with the most commonly used properties and methods that allow counting, adding, changing names and other tools for manipulating worksheets.
VBA uses objects to control Excel behavior so if you want to master this programming language and make the most of it you need to get acquainted with objects and collections, as well as with their properties and methods. In this text, I will introduce you to the most frequently used Excel objects: Application, Workbooks, Worksheets, Cells … In some of the following articles, we will deal more closely with each of them.
If we choose to create a complex Excel document that combines all the elements of a business process, we will try to call everything nicely, mark it, color it … During this process, we will create multiple worksheets, and sometimes give them long names in order to describe them as accurately as possible. The trouble is that the document can then become overloaded. The goal of this “recipe” is to show you a simple trick to find the desired worksheet faster.
The data we enter and process is often found in multiple spreadsheets. Depending on the version of Excel you’re using, after starting the program, each new document has one or more worksheets present. The number of worksheets appearing in each new document can be set in general options, and users can add, delete, move, change color or name of the worksheet on their own. The redistribution of the table on the worksheets can help you get a lot more organized.