Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Function 2nd argument | Excel Worksheet Functions | |||
Need Function Argument | Excel Worksheet Functions | |||
Function (array argument, range argument, string argument) vba | Excel Programming | |||
Function Argument | Excel Programming | |||
VBA - Passing a FUNCTION as an Argument | Excel Programming |