If I use function access in a basic macro to call the VLOOKUP function, a value is returned. How can I find out if that value is a string, of if it is a number?
For example, if the value returned by the function is “FISH”, but I have the following
oCell.value = svc.CallFunction(“VLOOKUP”, arg)
the cell assigned to oCell will have “0” in it. Is there any way I can tell whether the value returned by the svc.CallFunction(“VLOOKUP”, arg) call is text?