I am loosing formatting on the last sheet of my workbook.
I will send the code and workbook in a separate email.
After checking your code, I don’t think the formatting is lost but not set in your code. Please double check your WriteSheetHeading method. Please make sure mCurrentSheet is worked on all of your worksheet, including the last sheet.