| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to print 25 rows on each page in Excel
Hi, Can any body pl help me out For suppose I have 1000 rows in my excel sheet. My requirement is to get 25 rows in each page while printing... ie.,fixed no of rows in print sheets How to set the page settings in excel 97... or is there any programtically to do..... Thanx in advance.. with regs Suresh |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to print 25 rows on each page in Excel
One way:
Public Sub try() Dim i As Long Dim hpb As HPageBreak With ActiveSheet For i = 26 To .UsedRange.Rows.Count Step 25 .HPageBreaks.Add .Cells(i, 1) Next i End With End Sub In article , "Suresh" wrote: Hi, Can any body pl help me out For suppose I have 1000 rows in my excel sheet. My requirement is to get 25 rows in each page while printing... ie.,fixed no of rows in print sheets How to set the page settings in excel 97... or is there any programtically to do..... Thanx in advance.. with regs Suresh |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I print repeating rows on every page when printing? | Excel Discussion (Misc queries) | |||
| print first two rows (heading) and one row per page... | Excel Discussion (Misc queries) | |||
| How to print 2 worksheets (different col/rows) on the same page | Excel Worksheet Functions | |||
| How can I print noncontiguous rows on the same page? | Excel Discussion (Misc queries) | |||
| make first few rows print on every page? | New Users to Excel | |||
![Suresh[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
