Formula to show the content of a formula

  • Thread starter Thread starter David
  • Start date Start date
D

David

Hi,

Is there a way to show the actual content of the formula. I know you
can use the FIND function to search the content, but is there a way of
displaying it as well?

Kind of like hitting ctrl+` but ony for certains cells.

Say I want to check if "VLOOKUP" was used in column A. I would like to
put some sort of formula in column B, and if one it's used then to
show something like "check". Just so I know to go and check.

All feedback are appreciated.

Regards,
David
 
You can do it with a User Defined Function:

Function CellFormula(CellData As Range) As String
CellFormula = CellData.Formula
End Function

Now in a cell, call it with:

=CellFormula(A2)
 
Back
Top