반응형

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

+ Recent posts