Macro to setup Rows to Repeat at the Top
Who are you talking to?
Mine works no matter how many rows you select.
With ActiveSheet.PageSetup
.PrintTitleRows = Selection.Areas(1).Address
End With
--JP
On Mar 19, 12:39*pm, Steven wrote:
That is not what I am looking for. *That works if I want row 1 and 2. *But I
want to go with the current selection top row and bottom row because it will
not always be row 1 and 2 that I want to repeat. *I want to use the current
rows selected.
Thanks,
Steven
|