Macro to show a message when some cells in between before the last cell are empty

[Swagata]

Hi All,

I have a spreadsheet which has multiple rows and columns. Now I want to throw one single error message for all blank cells before the last cell with value. Below is a sample table:

sun	mon
tue	wed
	thur
fri	sat

Currently I have the the below macro which shows popup message for every blank cell before last cell:

For count3 = 1 To LastCol
        For RowCount = 8 To ws.Cells(Rows.Count, count3).End(xlUp).Row
       
        If Cells(RowCount, count3) = "" Then
            MsgBox ("Please give inputs in sequentially. Cells cannot be empty in between.")
        End If
        
       Next
    Next

Can any one please help me with these?