Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 2nd 04, 06:47 PM
mototrile_x
 
Posts: n/a
Default 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   Report Post  
Old November 2nd 04, 06:58 PM
Frank Kabel
 
Posts: n/a
Default

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   Report Post  
Old November 3rd 04, 04:31 AM
mototriple_x
 
Posts: n/a
Default

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   Report Post  
Old November 3rd 04, 04:46 AM
David McRitchie
 
Posts: n/a
Default

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   Report Post  
Old November 3rd 04, 10:10 AM
K.S.Warrier
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to copy formulas to other cells in excell eugene Setting up and Configuration of Excel 1 January 16th 05 11:25 PM
refreshing formulas in cells He4Giv Excel Discussion (Misc queries) 0 December 18th 04 10:11 AM
Excel: To Display Formula in the cells Instead of Value [email protected] Excel Discussion (Misc queries) 1 December 10th 04 09:48 PM
In Exel 2000, stop the blank cells (with formulas) from printing. tonyoc Excel Discussion (Misc queries) 1 December 10th 04 12:38 AM
delete values in several cells without deleting the formulas dranreb Excel Discussion (Misc queries) 4 December 9th 04 01:15 AM


All times are GMT +1. The time now is 03:06 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017