◈ VBA OBJECTS
(Excel object model for Visual Basic for Applications (VBA) | Microsoft Docs)
◈ Application Objects
- Application Objects는 응용 프로그램 전체 설정 및 옵션으로 구성
- ActiveCell, ActiveSheet 등과 같은 최상위 개체를 반환하는 메서드입니다.
- Application object (Excel) | Microsoft Docs
Application object (Excel)
docs.microsoft.com
◈ Workbook Objects
- Workbook Objects는 Workbooks 컬렉션의 구성원
- 현재 Microsoft Excel에 열려있는 모든 Workbook 개체를 포함
- Workbook object (Excel) | Microsoft Docs
Workbook object (Excel)
Workbook object (Excel) In this article --> Represents a Microsoft Excel workbook. The Workbook object is a member of the Workbooks collection. The Workbooks collection contains all the Workbook objects currently open in Microsoft Excel. The ThisWorkbook p
docs.microsoft.com
◈ Worksheet Objects
- Worksheet Objects는 Worksheets 컬렉션의 구성원
- 통합 문서의 모든 Worksheet 개체를 포함
- Worksheet object (Excel) | Microsoft Docs
Worksheet object (Excel)
Worksheet object (Excel) In this article --> Represents a worksheet. The Worksheet object is a member of the Worksheets collection. The Worksheets collection contains all the Worksheet objects in a workbook. The Worksheet object is also a member of the She
docs.microsoft.com
◈ Range Objects
- Range Objects는 셀, 행, 열 또는 하나 이상의 연속 셀 블록을 포함하는 셀 선택을 나타냄
- Range object (Excel) | Microsoft Docs
Range object (Excel)
Range object (Excel) In this article --> Represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3D range. Note Interested in developing solutions that extend the Office experience across multiple pl
docs.microsoft.com
'EXCEL VBA' 카테고리의 다른 글
엑셀 VBA 셀 선택하기(2) / .End(xlUp).offset(1, 0).select / End(3)(2).select (0) | 2020.11.22 |
---|---|
엑셀 VBA 셀 선택하기 (0) | 2020.11.22 |
엑셀 VBA 반복하기, For ~ Next (0) | 2020.11.21 |
엑셀 vba의 변수의 종류 (0) | 2020.11.21 |
VBA 변수 설정하기 (0) | 2020.11.21 |