sub or function argument

  • Thread starter Thread starter Jerry
  • Start date Start date
J

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
 
Try

=testfunction(A1)

Function TestFunction(C)
TestFunction = C
End Function

?T() is already a built-in function

If this post helps click Yes
 
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.
 
Try the below

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

If this post helps click Yes
 
Back
Top