반응형
Address Returns the reference of a cell or range, as text.
Columns Returns a Range object that represents a single column or multiple columns.
ConvertFormula Converts cell references in a formula between A1 and R1 C l-style, and between relative and absolute.
Evaluate Converts a formula to a value.
Intersect Returns the reference that is the intersection of two ranges.
Rows Returns a Range object that represents a single row or multiple rows.
Volatile Marks a user-defined function as volatile. The function recalculates whenever calculation occurs in any cell of the worksheet.
반응형
'VBA' 카테고리의 다른 글
Excel에서 특정 셀이 변경될 때 매크로 실행 (0) | 2022.01.23 |
---|---|
VBA's Built-in Data Types (0) | 2021.12.29 |
VBA Information 함수 일부 (0) | 2021.12.29 |
VBA text함수 일부 (0) | 2021.12.29 |
VBA 수학 함수 일부 (0) | 2021.12.29 |