Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The Null value can only be assigned to Variants, not to ranges.
The use of the Null variable is, that it propagates through expressions (like the value "infinity"). The expression rRow = NULL sets all the values in the range rRow to NULL. An object can never be set to NULL. Only a Variant can be either assigned the value NULL or set to an object or Nothing. So if you declare rRow as a Variant instead of a range it might even work, although I would not consider it very elegant. Example Definition of class Dirty : Private rRow As Variant Public Property Get GetRow() As Range If IsNull(rRow) Then Set GetRow = Nothing Else Set GetRow = rRow End If End Property Public Property Let SetRow(r As Integer) If r =< 0 Then rRow = Null Else Set rRow = Rows(r) End If End Property Public Property Get Value() As Variant Value = rRow End Property Main module: Sub P() Dim V As Dirty Set V = New Dirty V.SetRow = 0 If IsNull(V.Value) Then MsgBox "NULL" Else V.GetRow.Select End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF Function -- Return Null Value Help | Excel Worksheet Functions | |||
Return null | Excel Worksheet Functions | |||
how to get a function to return a null value that passes the ISBL. | Excel Worksheet Functions | |||
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
Can a function return a Null (blank ) value? Maybe a custom functi | Excel Worksheet Functions |