| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to get a number of rows in a given page?
automating excel 97
excel file is saved in page brake preview. I'm opening the file programmaticaly and need to figure how many pages, and how many rows on each page defined. -- Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to get a number of rows in a given page?
For Each s in Sheet
x = x + LstRow = s.UsedRange.Offset (s.UsedRange.Rows.Count - 1). Resize(1).Ro Debug.Print s.name & " Has " & LstRow & " Used Rows Nex Debug.print "Total number of sheets = " x ----- Gorr wrote: ---- automating excel 9 excel file is saved in page brake preview I'm opening the file programmaticaly and need to figure how many pages, an how many rows on each page defined - Thank |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to get a number of rows in a given page?
brilliant!
-- Thanks "chris" wrote in message ... For Each s in Sheets x = x +1 LstRow = s.UsedRange.Offset _ (s.UsedRange.Rows.Count - 1). _ Resize(1).Row Debug.Print s.name & " Has " & LstRow & " Used Rows" Next Debug.print "Total number of sheets = " x ----- Gorr wrote: ----- automating excel 97 excel file is saved in page brake preview. I'm opening the file programmaticaly and need to figure how many pages, and how many rows on each page defined. -- Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format page number in excel footer to start at a specific page # | Excel Discussion (Misc queries) | |||
| Configuring the number of rows printed per page | Excel Discussion (Misc queries) | |||
| Page Breaks- Printing selected rows on same page | Excel Discussion (Misc queries) | |||
| change and/or remove page number watermark in page break preview | Excel Discussion (Misc queries) | |||
| Print a number of rows per page | Excel Programming | |||
Hybrid Mode
