Function arguments without quotation marks



Hi group, again. One tricky question (I think). Is it at all
possible to pass arguments to a function without using quotation
marks? One example:

Function t(nome)
t = nome
End Function

On cell A1:

=t(abc)

Doing this I get on the cell the "#NAME?" error, and doing:

t = CStr(nome)

I get on the cell "Error 2029". However, doing:

=t(123)

No error happens. I don't know exactly why numbers can be passed
without quotation marks (but I think that it's because all non-numbers
are characters and characters are strings, maybe?)

Nevertheless, I would like to be able to use custom functions without
doing =t("abc"), but instead =t(abc)

Is it at all possible?

Sincere regards,
Marco

.



Relevant Pages

  • Re: Word 2002 Problem
    ... the cursor moves on revealing the quotation ... > characters are fine, it's just the two characters on that key, ... > single quotation and full quotation marks. ... be turned off in Control Panel | Regional and Language Options | ...
    (microsoft.public.windowsxp.basics)
  • Re: Word 2002 Problem
    ... >> Pro. ... the cursor moves on revealing the quotation ... >> characters are fine, it's just the two characters on that key, ... >> single quotation and full quotation marks. ...
    (microsoft.public.windowsxp.basics)
  • Function arguments without quotation marks
    ... On cell A1: ... without quotation marks (but I think that it's because all non-numbers ... are characters and characters are strings, ...
    (microsoft.public.excel.programming)
  • Re: Replacing unicode characters
    ... >but the pre-5.8 code just removes the characters for me. ... That turns out to be chr("right single quotation mark"). ... quotation marks" with quotes ...
    (comp.lang.perl.misc)
  • Re: array and countif help!
    ... that would fit in the Quotation award and Construction categories. ... I'm really sorry to push this. ... Example - Let's say you put a date in cell A1 of the ...
    (microsoft.public.excel.worksheet.functions)