Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to setup Rows to Repeat at the Top
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeat two rows macro please | New Users to Excel | |||
page setup won't allow entering "rows to repeat at top" | 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 | |||
Macro for Page Setup - Repeat rows at top | Excel Programming |