title: Trying to resolve an "invalid use of Null" in VBA
body: <p>Quick snippet first:</p>
  
  <pre><code>Dim GUID As String
  Dim givenNames, familyName, preferredName, gender, comments, carer, medicareNumber, patientNumber As String
  Dim dob As Variant
  Dim deceased, resolved, consultNotes As Boolean
  Dim age As Variant
  
  givenNames = Null
  familyName = Null
  preferredName = Null
  gender = Null
  dob = Null
  comments = Null
  deceased = False
  resolved = False
  carer = Null
  age = Null
  consultNotes = False
  patientNumber = Null ' This is where I get the error
  </code></pre>
  
  <p>Any idea why this last variable would be the one to trip up? I've assigned Null to a bunch of other strings without any errors.</p>