Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing null to a function
Hi,
I am trying to create a function to deal with nulls, but I'm enconntering an error (invalid use of null) by simply passing null to a function. The following code creates the issue Sub go() Dim sreturn As String sreturn = nulls("hello") MsgBox "return is :" & sreturn sreturn = nulls(Null) MsgBox "return is :" & sreturn End Sub Function nulls(instring As String) As String If IsNull(instring) Then nulls = "" Else nulls = instring End If End Function Does anybody have any ideas? Many thanks in advance Andy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero and Null Sum Function | Excel Worksheet Functions | |||
Passing a row to a function | Excel Worksheet Functions | |||
Passing a WorkSheet from a Function??? | Excel Worksheet Functions | |||
VBA - Passing a FUNCTION as an Argument | Excel Programming | |||
Passing array to a function | Excel Programming |