Ok, so I am relatively new to vba and i need to show a userform if a cell is empty, but for some reason it is not running correctly. Could i get some help or advice on how to better handle please.
Sub Aut
pen()
Worksheets("Report Disposition").Activate
If IsEmpty("D3:J3") Then
UserForm1.Show
Else
Worksheets("Variable Data").Activate
End If
End Sub

Sub Aut

Worksheets("Report Disposition").Activate
If IsEmpty("D3:J3") Then
UserForm1.Show
Else
Worksheets("Variable Data").Activate
End If
End Sub