User Defined formula, selecting range



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

.