I needed the number of horizontal pages. Before Tom showed me a simpler
solution that fit my needs, I was using this code in a longer routine to find
the number of horizontal pages:

ActiveSheet.HPageBreaks.Count + 1


--
tj


"bhofsetz" wrote:


How can the number of pages be determined programimatically?


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=384659