View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jerry Jerry is offline
external usenet poster
 
Posts: 142
Default sub or function argument

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