![]() |
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 |
All times are GMT +1. The time now is 01:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com