Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0301· OpenAIAi2 WildChat-4.8M (AI2)

How should I write this code so that it does not have errors: . . . Set…

  1. 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

  2. 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