Sub Try_This_For_Now()
Dim lr As Long, i As Long
Dim ma1 As Long, ma2 As Long
ma1 = Cells(3, 1).MergeArea.Columns.Count
ma2 = Cells(3, 17).Columns.Count
lr = Cells(Rows.Count, 1).End(xlUp).Row
    For i = 3 To lr Step Cells(3, 1).MergeArea.Rows.Count
        With Cells(i, 1)
            If .Value <> "" And .Offset(, 17 - ma1).Value <> "" Or .Value <> "" And .Offset(, 26 - ma1 - ma2 + 1).Value <> "" Then
                MsgBox "Data missing, try again!"
                    Else
                'Do here what needs to be done
            End If
        End With
    Next i
End Sub
Re: "I cannot unmerge the cells due to the nature of the form"
A re-design of the form is required. Might take some time but eliminates future problems.
Do a web search on why not to use "Merge & Center" in Excel. You'll be surprised at how many hits you'll get.