sub or function argument

[Jerry]

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

 

[Jacob Skaria]

Try

=testfunction(A1)

Function TestFunction(C)
TestFunction = C
End Function

?T() is already a built-in function

If this post helps click Yes

 

[Jerry]

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.

 

[Patrick Molloy]

how about

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

 

[Jacob Skaria]

Try the below

Function TestFunction(c As Range)
TestFunction = c.Address(False, False)
End Function

If this post helps click Yes

 

[Jerry]

Patrick/Jacob

Thats Superb! thanks men!

regards