Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for displaying formula
Hi,
Any code appreciated...I want to be able to run a dynamic function that would display the formula as text beside a cell that contains a formula...not every formula , but only those I run the function on it.. for example, in cell B20 if there is a formula =sum(B1:B19)...that displays the total of those cells above it... ...then just beside it in cell C20 if I type a function like = formula display (b20)...it would display =sum(B1:B19) and if I insert 5 or so more rows up top with 5 additional value cells in them, which would change the result in cell B24, the function in C25 would change automatically as well to display the new formula as text (such as =sum(B2:B24) thank you!!! Craig |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
displaying formula bar | Setting up and Configuration of Excel | |||
Displaying a Picture with a Macro | Excel Discussion (Misc queries) | |||
Same formula but ?value displaying | Excel Discussion (Misc queries) | |||
using a cell value to control a counter inside a macro and displaying macro value | Excel Worksheet Functions | |||
Help::how to run macro without displaying workbooks.. | Excel Programming |