Printing Range at the beginning of every new page.

  • Thread starter Thread starter Slick Willie
  • Start date Start date
S

Slick Willie

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.
 
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).
 
You must log in or register to reply here.

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

VBA set thick borders around non empty cells in range 0
Updated header information from cell 5
Userform textbox string to header causes unwanted double spacing 4
Named Range maker code 9
Setting Print Range 2
Post my named ranges in column A 10
Can't apply formating to header when a variable is used to represent cell contents 2
Populating 2 ranges with different random nums in each cell 7

Back
Top