Excel Reference To Current Cell

Question

How do I obtain a reference to the current cell?

For example, if I want to display the width of column A, I could use the following:

=CELL("width", A2)

However, I want the formula to be something like this:

=CELL("width", THIS_CELL)

Answer 1

Create a formula with the name THIS CELL.
Select cell A1 in the current worksheet (this is critical!)

(Ctrl+F3) to open the Name Manager

To begin, select New...

In the Name: field, type "THIS CELL" (or just "THIS," as I prefer).

In the Refers to box, type the following formula:

=!A1

Make sure that cell A1 is chosen. The ActiveCell is used in this formula.

Select Workbook from the Scope drop-down menu.

Close the Name Manager by clicking OK.

=CELL("width",THIS CELL)