How to determine Row and Column of cell

I am writing a simple function, and would like to know the row and column of the cell that initiated the function.

In a simple spreadsheet in Row 2 Col C I have =TestFunction()

In TestFunction how could I determine Row 2 Col C
Thank you very much
JoeBBB

How about

Please Login or Register  to view this content.

Thank you very much for your response. I tried it and placed the function in Row 5 Column 9 of the main sheet. In the function itself I set a variable
RowTest = application.call … The value in RowTest was "R5C9"
What I need to do is modify the row and column number to fetch a value. For example I might want to fetch from row 10 and Column 14 - modify provided row and column by 5 to get value. How do I isolate the Row and column number.
Again Thank you very much
JoeBBB

Most important - thank you very much for helping me. I am going to try to explain what I want more clearly I hope.

I want to create a function which will take the row and column of where initiated modify those values and fetch the contents of different location
Assume in Row - 3 Column C is the statement =FetchValue(AParameter)

Function FetchValue (Param)

TheRow= need to know how to determine the row of where function initiated result should Be 3
TheCol= how do I determine the column result should be either C or 3
'
'Modify TheRow and TheCol
TheRow=TheRow+20 add on a value determined elsewhere
'
'Similarly for TheCol
TheCol=TheCol+43

'lastly fetch value and exit function
FetchValue=Worksheets("SomeSheet").cells(TheRow,TheCol)
End Function


Again THANK YOU
Thank you
JoeBBB

thank you for you suggestions

You can use something like

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.