Macro for Page Setup - Repeat rows at top

Hi

I would like to be able to select the rows that should be repeated on each
page and then have a macro to put the rows in the field for rows to repeat
at top.

I have tried to record a macro, but I can't figure out how to have a
variable to put the rows in the field for rows to repeat at top.

Does anybody have such a macro?

Thanks in advance.
Kurt

Hi,

Will this work for you?

Option Explicit
Dim CountRows As Integer
Sub RowsAtTop()
CountRows = InputBox("Enter number of rows to repeat at top.")
ActiveSheet.PageSetup.PrintTitleRows = "$1:" & CountRows
End Sub

"epuk" wrote:

> Hi
>
> I would like to be able to select the rows that should be repeated on each
> page and then have a macro to put the rows in the field for rows to repeat
> at top.
>
> I have tried to record a macro, but I can't figure out how to have a
> variable to put the rows in the field for rows to repeat at top.
>
> Does anybody have such a macro?
>
> Thanks in advance.
> Kurt
>
>
>

Hello,

I would like to know how I can write a macro that will do the following:

1. Sort multiple rows of data for a number 70 or larger. If its less than
80 then delete the row.

2. Sort multiple rows of data for the letter A or B or C if D or E then
delete the row

3. How can I sort the data once it goes through the above macros to remove
any duplicate data based on the first column?

Thanks
Mike b

"epuk" wrote:

> Hi
>
> I would like to be able to select the rows that should be repeated on each
> page and then have a macro to put the rows in the field for rows to repeat
> at top.
>
> I have tried to record a macro, but I can't figure out how to have a
> variable to put the rows in the field for rows to repeat at top.
>
> Does anybody have such a macro?
>
> Thanks in advance.
> Kurt
>
>
>