Macro to setup Rows to Repeat at the Top
Great, Thank you.
"JP" wrote:
With ActiveSheet.PageSetup
.PrintTitleRows = Selection.Areas(1).Address
End With
On Mar 19, 11:18 am, Steven wrote:
I would like to create a macro to setup Rows to Repeat at the Top based on
the current rows selected. ie I would just select the rows and I plan on
using a menu bar macro button to run the macro. Therefore the macro needs to
know to use the currently selected rows to use as the rows to repeat at the
top.
I tried something like:
With ActiveSheet.PageSetup
.PrintTitleRows = Selection.Rows
End With
but thats not it. It returns an error.
Thank you for your help,
Steven
|