Have you added break points in the code to work out where it is halting? Your Sum_Up_Column_AutoFitColumns_1 macro ignores all errors - are you sure it isn't actually working but hitting errors
I have noticed you have mixed and matched ActiveWorkbook and ThisWorkbook. These could be two different workbooks depending on where the code is sitting.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
|