how about

Function TestFunction(C)
TestFunction = C.Address
End Function


"Jerry" wrote in message
...
thanks Jacob, but this will have a result of 12, not A1 as mentioned
earlier.
the result should be the argument itself not the passing value.

"Jacob Skaria" wrote:

Try

=testfunction(A1)

Function TestFunction(C)
TestFunction = C
End Function

?T() is already a built-in function

If this post helps click Yes
---------------
Jacob Skaria


"Jerry" wrote:

Hi All,

How can I access the argument in a function?

Example :

Let A1=12

function t(C)
**Codes????***
end function

B1=t(A1)

this function should have result of A1 not 12

thanks