Hello All,

My database building macro is working fine, but the users are not filling in all the information that would make my database complete.
I am trying to put some checking in at the start of the macro that would notify the user that they need to add more information in order for the entry to be made into the database.

My first few attempts look like this:

    If Range("v28:v77").Count < Range("b28").End(xlDown).Row Then
    
        MsgBox ("Supplier range incomplete: You must fill in supplier information")
    
        Exit Sub
    
    End If
As you can see, I'm trying to test if the count of cells with data in ColV is less than the cells filled in, in ColB. This is my way of determining that the user has not filled in the supplier name for each item that they are wishing to enter.

At the moment, when i test the macro it does not exit sub when the condition i am trying to test for is met.

It's probably worth noting that I will be testing for the not only ColV, but also F,G,H,K,L,W as well - if there is a way to do all of these checks in one statement then i'd accept that, even if it means that the error message is generic