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

Finding the properties of the Range object

Оглавление

Open the Visual Basic Editor and then go up to the menu and click Help ➪ Microsoft Visual Basic for Applications Help. You'll be taken to the Microsoft Developer Network (MSDN) website. While on MSDN, search for the word Range to see the page for the Range object. There you will discover that the Range object exposes three properties that can be used to manipulate your worksheets via VBA.

 The Range property of a Worksheet or Range class object

 The Cells property of a Worksheet object

 The Offset property of a Range object

Excel 2019 Power Programming with VBA

Подняться наверх