Is there any way to detect the cell position on a spreadsheet and return it as the value of a function (or maybe 2 functions, one for row and one for column) in VBA? I want to click on a cell and have its position recorded.

Many thanks