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

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

Function Gary()
Debug.Print Application.Caller.Address
End Function


--

HTH

RP
(remove nothere from the email address if mailing direct)


"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

Tom & Bob:

Thank you both very much.
--
Gary's Student


"Bob Phillips" wrote:

Function Gary()
Debug.Print Application.Caller.Address
End Function


--

HTH

RP
(remove nothere from the email address if mailing direct)


"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