Rows to Repeat at Top

April 7, 2008 – 3:51 pm by JP

If you want to programmatically set the "Rows to Repeat At Top" option on the Sheet tab in Excel's Page Setup dialog box, here are two ways to do it.

If you already know what range you want, you could use this code:

plain text version

VBA:

ActiveSheet.PageSetup.PrintTitleRows = "$1:$1"

This would set row 1 (which would ideally be a list of column headers) to print at the top of every page.

To set this option based on a user selection:

plain text version

VBA:

ActiveSheet.PageSetup.PrintTitleRows = Selection.Areas(1).Address

This code assumes that you have selected at least one entire row, i.e. select rows 1 through 4 then use the code above to set "Rows to repeat at top" to $1:$4.

HTH,
JP

Share and Enjoy:

Print This Post |

Email This Post | Permalink |

Subscribe now!

Filed Under: Excel, VBA
Tags: Excel, Rows to Repeat, VBA

This post has 447 views since April 7, 2008 – 3:51 pm.

One Response to “Rows to Repeat at Top”
Excellent tip!! I've always puzzled over how to do this.

Thanks for another awesome post. I love Excel

By mary on Apr 8, 2008