Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function query
Hi
I am writing an excel function in VBA for calculating Future Value of a selected range, where 1st cell is year1 and 2nd cell is year 2 and so on(i know already there is in built function for FV, but i need this as part of larger function i am writing) My code starts as follows: Public Function FutureValue(Rate As Double, CashFlow As Range) As Double CashFlow is selected as a range which can be any number of cells (say 5 or 10 or 20,etc). Now i need to know how many cells have been selected. I tried using Ubound(CashFlow) but that returns an error. Please help, its urgent!! Thanks a lot |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function query
Hi,
Number of cell within a range: CashFlow.Cells.Count -- Regards, Sébastien <http://www.ondemandanalysis.com "Rahul" wrote: Hi I am writing an excel function in VBA for calculating Future Value of a selected range, where 1st cell is year1 and 2nd cell is year 2 and so on(i know already there is in built function for FV, but i need this as part of larger function i am writing) My code starts as follows: Public Function FutureValue(Rate As Double, CashFlow As Range) As Double CashFlow is selected as a range which can be any number of cells (say 5 or 10 or 20,etc). Now i need to know how many cells have been selected. I tried using Ubound(CashFlow) but that returns an error. Please help, its urgent!! Thanks a lot |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Function query
It works:-)
Thanks a ton!! "sebastienm" wrote: Hi, Number of cell within a range: CashFlow.Cells.Count -- Regards, Sébastien <http://www.ondemandanalysis.com "Rahul" wrote: Hi I am writing an excel function in VBA for calculating Future Value of a selected range, where 1st cell is year1 and 2nd cell is year 2 and so on(i know already there is in built function for FV, but i need this as part of larger function i am writing) My code starts as follows: Public Function FutureValue(Rate As Double, CashFlow As Range) As Double CashFlow is selected as a range which can be any number of cells (say 5 or 10 or 20,etc). Now i need to know how many cells have been selected. I tried using Ubound(CashFlow) but that returns an error. Please help, its urgent!! Thanks a lot |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
query about VALUE function | Excel Worksheet Functions | |||
Function: New Web Query | Links and Linking in Excel | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) | |||
mid function in ms query | Excel Discussion (Misc queries) | |||
Excel Web Query Function | Excel Programming |