CONDITIONAL FORMULA

[Guest]

IS IT POSSIBLE TO WRITE A CONDITIONAL FORMULA WHERE THE LOGICAL CONDITION IS
EITHER A BLANK CELL OR A DATE?

THEN, IF THAT IS POSSIBLE CAN TRUE BE A COPY COMMAND AND FALSE A DOWN ONE
CELL COMMAND?

 

[Guest]

Hello,

Try the following:

Sub Conditional()
With Range("a1")
If IsDate(.Value) Or .Value = vbNullString Then
.Copy .Item(1, 2)
Else: .Item(2).Select
End If
End With
End Sub

Where .Item(1, 2) is one cell to the right.

Regards,
Nate Oliver