cell reference in a formula is called
 

Please confirm the correct answer to the below question

cell reference in a formula is called?

Answer: cell reference in a formula is called
 

Cell reference is used in a formula to refer to a specific cell or range of cells in a worksheet. It consists of the column letter and row number of the cell, such as A1 or B12.

1. When a formula is copied to other cells, the cell references may change automatically based on their relative position to the original cell. This is known as relative referencing.
2. Alternatively, cell references can be made absolute by adding a dollar sign ($) before the column letter and/or row number.
3. To create a cell reference in a formula, simply type the cell reference into the formula, or click on the cell(s) you want to reference while typing the formula.

I'm not sure what you are asking for. In a user defined function
in VBA, Application.Caller will return a Range reference to the
cell which called the function.

In a formula, ADDRESS(ROW(),COLUMN()) will return the address of
the cell containing the function.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"???????????" wrote in
message
...
Please confirm the correct answer to the below question

cell reference in a formula is called?