ExcelBanter - What cell am I in?

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - What cell am I in? (https://www.excelbanter.com/excel-programming/303033-what-cell-am-i.html)

Paul Lautman

What cell am I in?

The functions ROW() & COLUMN() if entered with no parameters return details
about the containing cell.

If I write my own function, what property tells me the containing cell?

Juan Pablo González

What cell am I in?

Application.Caller

returns a reference to the calling range from a UDF.

--
Regards

Juan Pablo González

"Paul Lautman" wrote in message
...
The functions ROW() & COLUMN() if entered with no parameters return
details
about the containing cell.

If I write my own function, what property tells me the containing cell?

Paul Lautman

What cell am I in?

Just what I needed, thanks for your prompt response Juan.

"Juan Pablo González" wrote in message
...
Application.Caller

returns a reference to the calling range from a UDF.

--
Regards

Juan Pablo González

"Paul Lautman" wrote in message
...
The functions ROW() & COLUMN() if entered with no parameters return
details
about the containing cell.

If I write my own function, what property tells me the containing cell?

All times are GMT +1. The time now is 01:02 PM.