Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy a Range of Data Beginning and Ending with a Certain Value | Excel Discussion (Misc queries) | |||
How do I set end-of-range to #rows from beginning | Charts and Charting in Excel | |||
Find the beginning Cell of a Range | Excel Discussion (Misc queries) | |||
HOW TO GO TO PAGE END LIKE GOING TO PAGE BEGINNING | Excel Worksheet Functions | |||
Excel Page Range Printing Problems | Excel Discussion (Misc queries) |