set rng = Application.Caller

should give you what you want.

--
Regards,
Tom Ogilvy


"Gary's Student" wrote in message
...
When a function is executed, the VBA system must know the location of the
cell in which the function call is located.

Is it possible for the code within a function to get the location in the
spreadsheet wihtout forcing the user to include it as an extra argument??

Thanks in Advance
--
Gary's Student