Using Excel function with variable

[ditzafar]

Could I use excel function when I don't know the range and I need to define it with variable.
If it possible, how I do it?
Thanks

[Steve Dalton]

Yes, using the INDIRECT function. But you need to know that this is
volatile.

Regards

Steve Dalton

"ditzafar" <[email protected]> wrote in
message news:[email protected]...
>
> Could I use excel function when I don't know the range and I need to
> define it with variable.
> If it possible, how I do it?
> Thanks
>
>
> --
> ditzafar
> ------------------------------------------------------------------------
> ditzafar's Profile:
http://www.excelforum.com/member.php...o&userid=29475
> View this thread: http://www.excelforum.com/showthread...hreadid=497502
>

[ditzafar]

What do you mean by indirect function.
thanks

Yes, using the INDIRECT function. But you need to know that this is
volatile.

Regards

Steve Dalton

"ditzafar" <[email protected]> wrote in
message news:[email protected]...
>
> Could I use excel function when I don't know the range and I need to
> define it with variable.
> If it possible, how I do it?
> Thanks
>
>
> --
> ditzafar
> ------------------------------------------------------------------------
> ditzafar's Profile:
http://www.excelforum.com/member.php...o&userid=29475
> View this thread: http://www.excelforum.com/showthread...hreadid=497502
>

[Niek Otten]

If you mean a User defined Function (UDF):

Function DemoSum(a As Range) As Double
DemoSum = a.Count
End Function

--
Kind regards,

Niek Otten

"ditzafar" <[email protected]> wrote in
message news:[email protected]...
>
> Could I use excel function when I don't know the range and I need to
> define it with variable.
> If it possible, how I do it?
> Thanks
>
>
> --
> ditzafar
> ------------------------------------------------------------------------
> ditzafar's Profile:
> http://www.excelforum.com/member.php...o&userid=29475
> View this thread: http://www.excelforum.com/showthread...hreadid=497502
>

[Bob Phillips]

See response in other thread

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ditzafar" <[email protected]> wrote in
message news:[email protected]...
>
> Could I use excel function when I don't know the range and I need to
> define it with variable.
> If it possible, how I do it?
> Thanks
>
>
> --
> ditzafar
> ------------------------------------------------------------------------
> ditzafar's Profile:
http://www.excelforum.com/member.php...o&userid=29475
> View this thread: http://www.excelforum.com/showthread...hreadid=497502
>

[ditzafar]

Sorry, but I stille didn't understand how I using excel function with variable.
For example I want to use the function average. the recorde of this macro looks like this
ActiveCell.FormulaR1C1 = "=AVERAGE(R[-6]C[-6]:R[3]C[-6])"
I want to replace the index of the row with variable
thanks

If you mean a User defined Function (UDF):

Function DemoSum(a As Range) As Double
DemoSum = a.Count
End Function

--
Kind regards,

Niek Otten

"ditzafar" <[email protected]> wrote in
message news:[email protected]...
>
> Could I use excel function when I don't know the range and I need to
> define it with variable.
> If it possible, how I do it?
> Thanks
>
>
> --
> ditzafar
> ------------------------------------------------------------------------
> ditzafar's Profile:
> http://www.excelforum.com/member.php...o&userid=29475
> View this thread: http://www.excelforum.com/showthread...hreadid=497502
>

[Niek Otten]

ActiveCell.FormulaR1C1 = "=AVERAGE(R[-" & VaraRowNo1 & "]C[-6]:R[" &
VarRowNo2 & "]C[-6])"

--
Kind regards,

Niek Otten

"ditzafar" <[email protected]> wrote in
message news:[email protected]...
>
> Sorry, but I stille didn't understand how I using excel function with
> variable.
> For example I want to use the function average. the recorde of this
> macro looks like this
> ActiveCell.FormulaR1C1 = "=AVERAGE(R[-6]C[-6]:R[3]C[-6])"
> I want to replace the index of the row with variable
> thanks
>
> Niek Otten Wrote:
>> If you mean a User defined Function (UDF):
>>
>> Function DemoSum(a As Range) As Double
>> DemoSum = a.Count
>> End Function
>>
>> --
>> Kind regards,
>>
>> Niek Otten
>>
>> "ditzafar" <[email protected]>
>> wrote in
>> message news:[email protected]...
>> >
>> > Could I use excel function when I don't know the range and I need to
>> > define it with variable.
>> > If it possible, how I do it?
>> > Thanks
>> >
>> >
>> > --
>> > ditzafar
>> >
>> ------------------------------------------------------------------------
>> > ditzafar's Profile:
>> > http://www.excelforum.com/member.php...o&userid=29475
>> > View this thread:
>> http://www.excelforum.com/showthread...hreadid=497502
>> >
>
>
> --
> ditzafar
> ------------------------------------------------------------------------
> ditzafar's Profile:
> http://www.excelforum.com/member.php...o&userid=29475
> View this thread: http://www.excelforum.com/showthread...hreadid=497502
>