how to get a number of rows in a given page?

G

Gorr

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.
 
C

chris

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
 
Top