Can I include blank cells in sort?

[ekinzie]

I have a simple spreadsheet with dates in column B & E. I have two VB scripts attached to buttons that will sort the data in either of those two columns.

Any empty dates in column E would indicate a problem. If I run the script to sort by this column, I would like any cell with no data to be brought to the top in no particular order. Any other solution would work so long as it would bring attention to these blank fields. Perhaps even another script to check for empty cells in column E? I don't know much about VB scripts and got this far by the help of others on this site so thanks for your help!

Heres the script:

Private Sub CommandButton2_Click()
On Error Resume Next
Application.EnableEvents = False
Me.UsedRange.Sort _
Key1:=[B2], Order1:=xlAscending, header:=xlYes, Orientation:=xlSortColumns
Application.EnableEvents = True
On Error GoTo 0
End Sub

Private Sub CommandButton1_Click()
On Error Resume Next
Application.EnableEvents = False
Me.UsedRange.Sort _
Key1:=[E2], Order1:=xlAscending, header:=xlYes, Orientation:=xlSortColumns
Application.EnableEvents = True
On Error GoTo 0
End Sub

And heres what we're looking at:

Any ideas would be greatly appreciated.
EK

 

[RalphA]

I think you may want to see my answer to a similar request at:
http://www.mrexcel.com/board2/viewtopic.php?t=127059

Another way: Highlight A1, click on Format, conditional Formating..., change the slot "Condition 1", "Formula Is" and write, in the slot to the right,
=COUNTBLANK(E1:E1), then click on Format there, and select the Patterns tab. Select a color, say red, then click on OK. Now, click on the Format Painter (the little yellow brush icon in the Standard Toolbar), then click on A2:E100. Now, every place there is a blank date, you should see a red row!

Let us know if one of the above helps you solve your problem.