I have the following macro that prints the top row whenever I print a worksheet:
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$1"
End With
Most of the time the row I want to repeat is either 6 or 11. Row 1 usually worksheet titles and not header data.
Can someone please think of a way where I can get a message box or input box to prompt me for a row number and then incorporate that number for the row number in the macro above?
Thank you.
Bookmarks