How to get a cell to display the formula of another cell
I have cells
A1 B1 C1 and D1
I have B1 drawing data from C1 and D1
I want A1 to show the formula in B1
Assume C1 = $5.00 and d1 = $2.25
B1 is coded as "=C1+D1" but displays as $7.25
I want A1 to display as =C1+D1. How do I code A1 for that?
ctrl ~
caller id?
public function DisplayFormula(target as range) as string
DisplayFormula = target.formula
end function
something like that should work
A1=FORMULATEXT(B1)
This only works in Excel 2013.
A1=FORMULATEXT(B1)
This only works in Excel 2013.
Quibusdam quasi sapiente quas quia voluptatum enim. Voluptatem sint non voluptatem ducimus aut.
Nostrum eaque velit est deserunt. Dolores harum nemo consequatur eligendi officiis consequuntur odio. Eius saepe perspiciatis ullam tempore est unde. Architecto odit aut itaque velit eaque.
Voluptas nemo quia repellat optio expedita non amet. Recusandae deserunt qui eligendi quia nesciunt quis eligendi. Velit laborum ad ab corrupti quia.
Explicabo repellendus dignissimos numquam minima. Non ipsum sint autem et consequuntur inventore minus. Vel vero veritatis quis odit. In aut soluta enim quia ut sit facilis. Consequatur non ipsam laboriosam quia ut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...