Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i display formulas in only certain cells?
i need to display 9 cells functions and the rest the value of the function
|
#2
|
|||
|
|||
Hi
you'll need VBA. e.g. the following kind of UDF: public function get_formula(rng as range) if rng.hasformula then get_formula=mid(rng.formula,2,1024) end if end function Now if your formula is in cell B1 use =GET_FORMULA(B1) -- Regards Frank Kabel Frankfurt, Germany "mototrile_x" schrieb im Newsbeitrag ... i need to display 9 cells functions and the rest the value of the function |
#3
|
|||
|
|||
sorry, i must not be up to speed on the abreviations, please tell me what
"VBA" and "UDF" stand for. i tried =get_formula(C5) for a formula in cell C5. the formula is =PMT(C$4/12,$A5,$L$2) and i need it to be displayed along with others in another section of my worksheet thanks mototriple_x |
#4
|
|||
|
|||
VBA is Visual Basic for Applications, it is the language that
used for user macros (programmed coding) in Excel. UDF is User Defined Function, which are like the builtin Worksheet Functions but are user written. To install a UDF see my page http://www.mvps.org/dmcritchie/excel/getstarted.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "mototriple_x" wrote in message ... sorry, i must not be up to speed on the abreviations, please tell me what "VBA" and "UDF" stand for. i tried =get_formula(C5) for a formula in cell C5. the formula is =PMT(C$4/12,$A5,$L$2) and i need it to be displayed along with others in another section of my worksheet thanks mototriple_x |
#5
|
|||
|
|||
Hi,
In the edit menu, click the clipboard.Copy the values of cells selected required in the clipboard(maximum 12 numbers) and click this from clipboard to the required cells. K.S.Warrier "mototrile_x" wrote: i need to display 9 cells functions and the rest the value of the function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to copy formulas to other cells in excell | Setting up and Configuration of Excel | |||
refreshing formulas in cells | Excel Discussion (Misc queries) | |||
Excel: To Display Formula in the cells Instead of Value | Excel Discussion (Misc queries) | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
delete values in several cells without deleting the formulas | Excel Discussion (Misc queries) |