This might be a stupid question but why aren't you using

File- Page Setup- Sheet (tab)- Rows to Repeat at Top

Placing those values in the header will be problematic in terms of spacing.
If you have to use the header then you will likely need to switch to a
proportional font for all of your formatting (such as Courier).

"Slick Willie" wrote:

I've experimented with CenterHeader = Range("A1:H5").Value
The only cell used in the header is A1. Also I need the names in my
range to line up with their columns. Any help would be greatly
appreciated.