Return no of rows per page

  • Thread starter Thread starter Neil Waterworth
  • Start date Start date
N

Neil Waterworth

Hi,

I'm fairly new to this, but is there a property which returns the number of
rows per printed page.

Specifically, I want to setup the page, then populate a worksheet, but
insert column headers on each page. There may be a better way to do this.

Thanks for any help,
Neil
 
Think you would have to examine the horzontal page breaks collection
hpagebreaks

However, unless you put data in your worksheet first, they probably won't
tell you much. You may need to put in your data and then work down from the
top, adding lines and putting in your headers.
 
Go to Page Setup - > Sheet -> Rows to Repeat at Top or Columns to Repeat at
Left.

This automatically puts column or row headers on each printed page.
 
Thanks,

ActiveSheet.PageSetup.PrintTitleRows = "$1:$2" got me there.

Neil
 
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

Changing header text from one page to another 1
Tax Form with Merge and Center 7
Find last row and column for 1st page only 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Access Sorting and grouping using multiple tables 0
How to know the correct height of the row 2
Find Specific Rows in Range and Create New Tab 18
return row header as answer 2

Back
Top