Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 45
Default Determine maximum length of a page

Hi:

ActiveSheet.HPageBreaks(1).Location.Row - 1

will give you the last row in the first page. In general, this would then
give you the number of rows that would fit on a page, assuming they were all
the same height, no rows were repeated at the top, etc., etc.

Regards,

Vasant.

"MacroMan" wrote in message
...
Please Help!

I am using VBA in Excel XP with Windows 2000.

I think this is a tough one, but it would help me
immensely:

Is there a way to determine the maximum number of rows per
page, given the current print settings of any particular
sheet?

Perhaps a calculation based on the row height, etc?

Your example code would be most appreciated. Thanks in
advance for your assistance...



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maximum length of file name? Eric_NY Excel Discussion (Misc queries) 3 June 1st 09 09:51 PM
How to determine the arc length in Excel? Eric Excel Discussion (Misc queries) 5 September 16th 07 04:20 PM
Maximum length of a number Pé Excel Worksheet Functions 1 October 31st 06 12:42 PM
what is maximum row length in excel dlb1228 Excel Discussion (Misc queries) 2 August 10th 05 02:13 PM
maximum formula length skywalker99 Excel Worksheet Functions 2 March 1st 05 10:30 PM


All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"