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

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
>
>

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
> >
> >