• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Function - Access cell address from which function is being called

Status
Not open for further replies.
polarisking

polarisking

Member
Note: I had posted this incorrectly to the general Excel forum initially.​
Hopefully, this is an easy one. I have a Function that needs to know the Row & Column in which the Function is being executed. If I use the Function many times on the same worksheet, it's returning the same value in every cell since I'm, incorrectly, pointing to Active.Row and Active.Column.​
​
How do I pass, implicitly, the row and column of where the Function is being called from so in the case of the Function returning the cell address; it would return A3 and G6 respectively if I have the Function in both cells?​
​
SOLVED​
​

Function CellAddress() As String​

CellAddress = Application.Caller.Address(0,0)​
​
End Function​
 
Status
Not open for further replies.
Back
Top