To make my question simpler - I am looking for a way, using VBA in excel, to look up a piece of data in one row (in my case a range of dates starting in row A7) and then check to see if rows H:M are all blank.

All my dates will always be in order (12/1, 12/2, 12/3...,12/31)

The start date is kept in B2 and the end date in B3.

I found a piece of code which can find the dates but then searching for the blanks in between that date range AND reporting which dates are missing data... well. Help? 

'---check to make sure all data has been entered---
LookupColumn = "A" '---Define the LookupColum---
StartDate_Value = wsOrder.Range("B2").Value '---Use whatever you need to define the input values---
EndDate_Value = wsOrder.Range("B3").Value '---Use whatever you need to define the input values---

For i = 1 To 30000
    If wsOrder.Range(LookupColumn & i).Value = EndDate_Value Then EndDate_Row = i
Next i

For j = EndDate_Row To 1 Step -1
    If wsOrder.Range(LookupColumn & j).Value = StartDate_Value Then StartDate_Row = j
Next j

Dim MyDateRange As Range: Set MyDateRange = wsOrder.Range(LookupColumn & StartDate_Row & ":" & LookupColumn & EndDate_Row)
MsgBox "All Data has been entered for Period = " & StartDate_Value & " - " & EndDate_Value