sub or function argument
 

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

sub or function argument
 

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

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

sub or function argument
 

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

sub or function argument
 

Try the below

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

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


"Jerry" wrote:

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

sub or function argument
 

Patrick/Jacob

Thats Superb! thanks men!

regards

"Jacob Skaria" wrote:

Try the below

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

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


"Jerry" wrote:

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