Understand your argument..

Let me shed a little background here. We get submissions from our Secondary Marketing and Shipping teams. One of the spreadsheets we get is for "Loan Sales" and the other is "Loan Sales Data." The first column (which is what we check) is always a Loan Number and when it comes across a blank record the process stops. As user of this process, why should I care how many rows are input? The only thing that I care, as a Developer of this is that the data is in proper column and is complete.

This code originated from a Access Database that I developed some VBA Code and a vendor provided COM Object to update our Loan Origination System.

Thanks,

Kent
_________________________
Utilize these resources:
UDFs (Full List)
KiXtart FAQ & How to's