How should I write this code so that it does not have errors: . . . Set…
- User
How should I write this code so that it does not have errors: . . . Set adminReminderCell = Nothing
If Not wscf Is Nothing Then Set adminReminderCell = wscf.Range("B:B").Find("Reminder", , xlValues, xlWhole, xlByColumns) End If
''''''If Not adminReminderCell Is Nothing Then 'Reminder Found If Not adminReminderCell.Offset(0, 7).Value = "" Is Nothing Then ' Modification to check if complete date is blank Call EnterCheckReminder
- Assistant
(adminReminderCell) End If 'End If
The corrected code is:
Set adminReminderCell = Nothing
If Not wscf Is Nothing Then Set adminReminderCell = wscf.Range("B:B").Find("Reminder", , xlValues, xlWhole, xlByColumns) End If
If Not adminReminderCell Is Nothing Then 'Reminder Found If adminReminderCell.Offset(0, 7).Value = "" Then ' Modification to check if complete date is blank Call EnterCheckReminder(adminReminderCell) End If End If