Hi again,
Thanks for your response.
I believe you. Once I figured out the save as xlsx issue I experienced, and
found/modified a macro to auto-operate all of this, it processed 32 files in
7 minutes, and only failed with the 33rd file. So, in my mind it goes without
saying that this is an awesome routine you've provided, and I am extremely
grateful.
Ok.... difficult to debug.
Do you have ideas that might give me a direction to start?
What kinds of things would cause that variable to go to zero? I saw that you
set the lngLastRow = 1, if it was zero.
If lngLastRow = 0 Then
lngLastRow = 1
intLastColumn = 1
End If
would I need to do something identical with the intLastColumn too?
I.e.,
If intLastColumn = 0 Then
lngLastRow = 1
intLastColumn = 1
End If

I looked at the last file I worked, and there were no worksheets that were
blank, or had only one column with data. I.e., all of the worksheets had
plenty of data on them. So, I do not understand why intLastColumn would go to
0.