Hi,
I am looking for some VBA that will tell my function what cell it is in, for example:
Code
function wibble()
wibble = ("I am in cell " & X & "or column " & 1 & " and row " & 2)
End function
The output would be: 1 am in cell A1 or column 1 and row 1
On an Excel worksheet the equivalent is "=ROW()" or "=COLUMN()" but there does not appear to be an application.worksheetfunction equivalent.
Many thanks
James