Only a small part of your code has been fixed, but if I understand this correctly, one macro (fullmacsro) calls a sequence of events. The first sub called from that one (FillCells) is the one that should stop the rest from happening if there are blanks? What is the meaning of the Cancel variable? It does not seem to be used, just assigned a true or false value.
If I understand correctly you would like the code to stop in this area:
Cancel = True will not just stop the program, and if that is what you expected, then the code is supposed to stop running completely at that point? You could replace it with:
which would message "Incomplete Data" and then just stop all code from running right after.
Bookmarks