Using VBA To Input Headers Into Report

I have a report that was built using Crystal Reports that I export into an Excel worksheet because, well, it is typically easier to pull in the additional data I need. I am writing a macro to do the formatting and such and wanted to find a better way to add column headers to the report but I can't seem to make it work.

I have other workbooks where I have to do some extensive formatting that I use application.transpose (array... to get vertical labels down a column, but I can't seem to find the verbiage to do the same thing across the top. I would put the header labels in the Crystal Report but the formatting always seems to be out of kilter when I do that so I am only importing the data from the report.