| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Header from a range of cells on another sheet so that cell width can be different
I have found lots of examples of how to use the beforeprint event to
print a single cell in the headers. I have a database on one sheet that has column widths that do not line up with the column widths in my header. I'd like to be free to set up the header on another sheet in a range of A1:L5 as the header when I print the database. Can this be done with VBA. If so can you provide an example of the code. Is there another way with VBA. The page setup use rows and columns require the header to on the same page with the same widths? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change the width of the Header panes so text will fit | Setting up and Configuration of Excel | |||
| How can I select a range of cells for header? | Excel Programming | |||
| Seeking Help with Cell/Range Height and Width Properties | Excel Programming | |||
| Creating a Dynamic Named Range Using Sheet Name and Column Header | Excel Programming | |||
| hOW DO i CHANGE COLUMN WIDTH FOR ONLY A SELECT RANGE OF CELLS? | Excel Discussion (Misc queries) | |||
Hybrid Mode
