Читать книгу Excel 2019 Power Programming with VBA - Michael Alexander, Dick Kusleika - Страница 129

All the macro syntax you will ever need has likely been documented somewhere on the Internet. In many ways, programming has become less about the code one creates from scratch and more about how to take existing code and apply it creatively to a particular scenario.

If you are stuck trying to create a macro for a particular task, fire up your favorite online search engine and simply describe the task you are trying to accomplish. For the best results, enter Excel VBA before your description.

For example, if you are trying to write a macro that deletes all the blank rows in a worksheet, search for Excel VBA delete blank rows in a worksheet. You can bet two months' salary that someone out there on the Internet has tackled the same problem. Nine times out of 10, you will find some example code that will give you the nugget of information you need to jump-start some ideas for building your own macro.