Alan Moseley IT Consultancy

Blog Entry

5/12/2008 - How to determine the Excel cell from which a function was called

During the creation of an Excel user-defined function, I needed to determine which cell the function was being called from. The answer was to use the following line of code:-

Application.Caller.Address