If selected cell is blank or the first character is # then run marco.

[bluefeather8989]

If selected cell is blank or the first character is # then run marco.

 

[Micron]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target = "" Or Left(Target, 1) = "#" Then
    MsgBox "do something"
End If

End Sub