Losing format information in For Loop iterations

Hi All,

I now have my spreadsheet working as I want it to, apart from one last niggling annoyance. The code below works fine to send the data to my template but it only applies the formatting to the first 2 iterations and I can't figure out why!

Anyone able to see the flaw?

Please Login or Register  to view this content.

Nothing obvious jumps out at me. Is the IF condition definitely met beyond 2?

Definitely working as it is passing the information to the template fine for each loop, just stops bothering to format it after loop 2

I think you'll have to post a workbook.

I believe the term "numpty" could be applied to myself. Just realised that there is nothing wrong with the code, someone had applied cell formatting to the template

Thanks though StephenR

Ah, hadn't thought of that. It could happen to anyone, honest.