I am using Excel 2003, recently upgraded to service pack 2. I have a
macro that opens a delimited text file, I then copy all, paste values
and number formats and then run a macro that subtotals a balance by
change in every consumer.

The problem is that when, upgraded to service pack 2, the last record
does not subtotal, all other records do.

I have tried copying only the "live" data after the marco opens the
text file. Still the same error.

I have tried pasting different ways - values, normal paste, paste
values and number formats.

Same thing happens - the GRAND TOTAL - ends up way on the bottom, and
the last record is not subtotaling. It is as if it thinks there is no
change in the record. Your help is appreciated. When I run the same
macro on my laptop, ( not upgraded to SP 2) it works fine.

Your help is appreciated.

Kenlyn