Style issues with SaveAs

Hello,

I have created a macro that pulls data from a CSV file, does some calculations and presents the data on a worksheet with specified style options such as bold, merge cells, etc...The macro seems to work fine and the worksheet is created and printed properly, but when the file saves to a specified folder, that saved file has lost all the style settings. Any suggestions would be greatly appreciated.