Worksheet loses formatting?

[NPD071]

Hello All, Captain Strangequestion reporting for duty.....

Here is my dilemma...I have a workbook that has several sheets that have different formattings for different cells (ie currency, dates, etc). They populated resultant of VB codes and were working great for about a month...absolutly no issues at all.

Now, the cells have lost their formatting and I am unable to repair this. When I recreate the sheet, the formatting works fine...then...at some point in the use of the workbook, the formatting is lost again. I KNOW it must be a code issue somewhere but I can't track it down. As this project is a work in progress, I'm sure that I messed up a code but don't know where.

Is there a code or setting that I can look at that controls this? Again, even if I try to reformat the cells on the effected sheet, it will not work. I have to recreate a brand new sheet, cut and paste the values to the new sheet and strangely, the correct format follows to the new sheet.

What did I screw up? ...

Thanks in advance...