Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Page Setup - Repeat rows at top
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for Page Setup - Repeat rows at top
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to repeat 2 contiguous rows to top of each page | Excel Discussion (Misc queries) | |||
page setup won't allow entering "rows to repeat at top" | Excel Discussion (Misc queries) | |||
Need rows to repeat Except for last page | Excel Discussion (Misc queries) | |||
Page Setup - Rows To Repeat At Top | Excel Discussion (Misc queries) | |||
"Rows to repeat at top" option under page setup | Excel Worksheet Functions |