Cell address of function call

's Computer Specifications

I have a function in my spreadsheet and I would like to know within that code
what cell the function is being called from, but I have no idea how to
achieve this. Perhaps somebody here can point me in the right direction?

's Computer Specifications

I've found it. Application.Caller.Address seems to do the job nicely.

"PatrickS" wrote:

> I have a function in my spreadsheet and I would like to know within that code
> what cell the function is being called from, but I have no idea how to
> achieve this. Perhaps somebody here can point me in the right direction?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Call a function when a cell changes	henpat	Microsoft Excel Programming	1	16th Nov 2005 01:24 PM
Call VBA function from cell	=?Utf-8?B?ZG9uZXNxdWlyZQ==?=	Microsoft Excel Programming	4	20th Apr 2005 05:49 AM
Can I call a VB function by address?	=?Utf-8?B?aGFtaWw=?=	Microsoft VB .NET	2	8th Oct 2004 08:12 AM
call a vb function from a cell	mike grasso	Microsoft Excel Programming	3	9th Jul 2004 01:51 PM
How do I call a VBA function from a cell?	Scott Lyon	Microsoft Excel Programming	1	14th Oct 2003 06:55 PM