Hi, i think we cannot insert Null directly from excel, have to do some coding part, so i have tried the following code which is working:
Sub addStudentInformation(firstName, lastName)
'Assuming that values are coming from excel file
If firstName = "" Then
application.firstName.value = "" 'Inserting Null value to FirstName
Else
application.firstName.value = Excel.Value(0) 'ExcelColumn
End If
or
If Not firstName = "" Then
application.firstName.value = Excel.Value(0) 'ExcelColumn
End If
in that case TC will left the first name as it is and move to the next field.
You may have to do this for all fields.