![]() |
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? |
All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com