Printing Range at the beginning of every new page.
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. |
Printing Range at the beginning of every new page.
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. |
All times are GMT +1. The time now is 12:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com