Home |
Search |
Today's Posts |
#9
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() I did not get a chance to work on it today but it is VBA code that calculates a definite integral (area uder the curve) It is a simple matter to use this VBA code. I named the function "integrateTrapz" You use it just like a normal math function in excel such as SUM or ABS It will take the values ot whatever is in the cell range that you want to use as input. There is a bug in my code and I'm trying to presently get it fixed. I has been some 5 years since I have done any programming. I was an expert with Quick Basic but it seems visual basic has many changes from quick basic. Trivia The last version of quick basic came out in 1988 (v4.5) -- integreat ------------------------------------------------------------------------ integreat's Profile: http://www.excelforum.com/member.php...o&userid=34282 View this thread: http://www.excelforum.com/showthread...hreadid=497266 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Integration/area under a curve VBA code? | Excel Discussion (Misc queries) | |||
Change case...help please | Excel Worksheet Functions | |||
Macro for changing text to Proper Case | Excel Worksheet Functions | |||
Using other workbooks.. | Excel Worksheet Functions | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions |