Re: User Defined formula, selecting range

From: "Arvi Laanemets" <garbage@xxxxxx>
Date: Thu, 5 Jan 2006 11:01:11 +0200

Hi

Selecting a range on worksheet does change worksheets state physically -
what is not allowed for functions in Excel by definition. Forget it, or use
a procedure instead.

--
Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

<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

Prev by Date: Copy Rows from one work*** to another by entering the Name of the Staff
Next by Date: Re: a macro to run on all the file in the same folder
Previous by thread: User Defined formula, selecting range
Next by thread: Re: User Defined formula, selecting range
Index(es):
- Date
- Thread