title: VBA How to return null from a function
body: <p>I have this function </p>
  
  <pre><code>Public Function parseEmployee(ByVal employeeId As Integer, _ 
                                ByVal ws As Worksheet) As employee
      Dim emp As New employee
      Dim empRow As Range
      If sheetContainsEmployee(employeeId, ws) Then
          Set empRow = ws.Rows(ws.Columns(ID_COLUMN).Find(employeeId).Row)
          emp.id = employeeId
          emp.Name = empRow.Cells(1, NAME_COLUMN).Value
      Else
          emp = Null ' Heres what I'd like to do
      End If
  
      parseEmployee = emp
  End Function
  </code></pre>
  
  <p>And I'd like to return null in case that the employee is not found in the sheet, is that possible? I get an object or variable nblock not set. error</p>