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

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

 

[Guest]

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

 

[Gorr]

brilliant!