Forum Discussion
activecell (single word not 2) statement
This is actually a 2 parter: 1st can anybody tell whether activecell.offset(2,2) or activecell.formula or activecell.font or any of the other dot extensions are available for use in CELL FORMULAs...
ActiveCell is VBA, it cannot be used in cell formulas (except through custom VBA functions).
You can refer to the cell 2 rows below and 2 columns to the right of the cell with the formula: for a formula in B2, use OFFSET(B2, 2, 2). When you copy this to other cells, Excel will automatically adjust the reference to B2.
A cell formula cannot return its own formula, that would be a circular reference.
To return the font of the cell with the formula requires VBA or Excel 4 Macro.
- Thank you for timely (and informative) response. Will consider your input.
