Function arguments without quotation marks
- From: "marco" <mferra@xxxxxxxxx>
- Date: 28 Feb 2007 14:28:51 -0800
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
.
- Prev by Date: Function arguments without quotation marks
- Next by Date: Re: Userforms in a separate work***
- Previous by thread: Re: Function arguments without quotation marks
- Next by thread: Re: Userforms in a separate work***
- Index(es):