My function needs to know what cell, row and column it is in?

Hi,

I am looking for some VBA that will tell my function what cell it is in, for example:

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

Re: My function needs to know what cell, row and column it is in?

Many thanks!