

Exercise 20: View the Formula of cell in another Cell
1. Create a UDF Formuladisplay (User Defined Function)
To create this Function, execute the following steps
Insert the below code in a New Module
This Code lines will create function Formuladisplay () , In Cell D1 Type
= Hedqtrs( (C1)
Syntax FORMULATEXT(reference)
2. Use Excel Formulas (FORMULATEXT)
=FORMULATEXT(C1)