How to insert custom in Excel using Applescript?

I am using Applescript to create a macro where data is passed from multiple files to one file. The data is copied using

copy range the_range destination clipboard

      

        
        
        
      

    

and insert with

paste worksheet active sheet destination range "A1"

      

        
        
        
      

    

The problem is that most of the formatting is lost and I was unable to get the "paste special" -syntax setting correct. I downloaded "Excel2004AppleScriptRef.pdf".