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.
Debitis delectus dicta voluptas voluptatem ex voluptatem id. Tenetur cum ea similique quod velit. Asperiores laudantium repellendus explicabo quis nobis. Non in quisquam id et quos aliquid. Architecto quo numquam consequatur velit quia suscipit aut.
Repellendus animi eveniet alias in quasi. Unde vero eius id at. Reiciendis eius dolorem et praesentium et eos. Corporis eos incidunt libero laboriosam rerum accusantium in. Fugiat possimus et dignissimos atque eius ut tempora in.
Voluptatem ducimus praesentium a quia excepturi accusamus. Magnam nulla corrupti distinctio laboriosam distinctio aut consequatur quia. In neque autem repellat autem quia. Nobis quasi consequatur consequatur sit sed harum sint. Qui sint ratione amet quam non autem.
Autem officiis aliquam assumenda. Est numquam dolores voluptas id. Laboriosam a quis ut qui eum. Eveniet atque similique in et recusandae provident.
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...