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

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

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