Using Header from a range of cells on another sheet so that cell width can be different

D

dollinger64

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find string from column A in Range("B2:F7") list the header of that column/s 5
Find Specific Rows in Range and Create New Tab 18
Macro to Combine Data from Multiple Sheets with Cell References 4
Apply cell formatting using VBA 2
Loop through cells to find a string and copy/paste the matching column to a new wkbk 3
Make protected hidden row & column headers appear and rehide based ona cell's value 2
Unable to set the desired column width for a table with merged cells 0
Copy columns by Header and select all data (non-contiguous) from those columns 8

Top