I would set a break point in the macro and then step through the code to find
the problem.

Open VBA editor and press F9 on first line of code (nmot CONST or DIM
statements).

Then go back to excel spreadsheet and activate macro. Use F8 to step
through code to locate the problem.

"Clayman" wrote:

Y'all are gonna get so tired of me...

OK - with my error question earlier today, I need to call a userform, enter
data, and return to processing the rest of the data. Problem is, when I click
OK on the form, it unloads the form and stops processing. Basically, it
terminates the module. How do I get it to continue processing after clicking
OK?

Right now, it relies on the BTNok_Click() event to process the data. Is this
bad?
--
Adios,
Clay Harryman