This issue is a little hard to explain but I will do it with an example:

I want to create a formula (VBA) which will be used in a table in each line and a specific column, letīs say column T. So the sheet has this formula in each line of column T.

The function gathers information from different parts of the Excel Workbook and depending on this information needs to return a value.

There is a case when the function needs to get the information of column AT of the same line as the function is placed.

How can I refer to a cell of the same line where the funcion is being used? I mean, how can I hand over to the function the current line from where the function is being called?

Or is there any command to be used in VBA inside the function to track back from which cell coordinates the function is being called?

Thanks!