Reports....

With reference to above...

What is new module ? And Sub ?

7. Add a Module to your Worksheet and add a Sub named something like ImportCVS:
Public Sub ImportCSV(bCode As Boolean)

Do you do this process once ?
Are you basically creating a template with formating as you want...then you're copying it everytime with new data in ?

Cheers
Neil

With reference to above...

What is new module ? And Sub ?

7. Add a Module to your Worksheet and add a Sub named something like ImportCVS:
Public Sub ImportCSV(bCode As Boolean)

Do you do this process once ?
Are you basically creating a template with formating as you want...then you're copying it everytime with new data in ?

Cheers
Neil