Re: User Defined formula, selecting range
- From: "Peter Beach" <pbeach@xxxxxxxxxxxx>
- Date: Thu, 5 Jan 2006 22:10:10 +1300
Hi Robert,
User-defined functions don't quite work like that I'm afraid. UDF's are
simply functions like any other XL function (e.g. AVERAGE) but you can write
them yourself to meet your exact requirements. So just like the AVERAGE
function, UDF's expect input parameters and are only recalculated when those
input parameters change (well there are a couple of exceptions to that rule
but probably not relevant to your situation).
Perhaps you could describe exactly what it is that you are trying to
accomplish?
Regards,
Peter Beach
<p.strijbosch@xxxxxxxxx> wrote in message
news:1136450888.344569.95140@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hello,
>
> Can someone tell me how to make a user defined formula in Excel that
> ables one to select a (flexibel) range.
> The formula has to be something similar to the standard VBA statement:
>
> Activecell.Select
> Selection.End(xlDown).Select
>
> Thanx a lot for your help!!!!
>
> regards,
> Robert
>
.
- References:
- User Defined formula, selecting range
- From: p . strijbosch
- User Defined formula, selecting range
- Prev by Date: Re: a macro to run on all the file in the same folder
- Next by Date: extracting data
- Previous by thread: Re: User Defined formula, selecting range
- Next by thread: Re: User Defined formula, selecting range
- Index(es):
Relevant Pages
|
