| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to know the number of lines on the sheet?
How can I tell how many lines will be printed for a sheet in a workbook
Sorry, I'm a real newbie to Excel and VBA. A consultant created thi and he is now gone and my boss wants some changes. The only way I can think to make the changes means that I need to kno how many lines will be printed -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to know the number of lines on the sheet?
Go to tools=Options and in the View Tab under Windows Options, make sure
pagebreaks is checked. You can then see where the pagebreaks are and count the rows. In code, you would use the hpagebreaks collection to find the same information. -- Regards, Tom Ogilvy dizzy wrote in message ... How can I tell how many lines will be printed for a sheet in a workbook? Sorry, I'm a real newbie to Excel and VBA. A consultant created this and he is now gone and my boss wants some changes. The only way I can think to make the changes means that I need to know how many lines will be printed. --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy lines from sheet 2 to sheet 6 | New Users to Excel | |||
| Populate sheet with lines from another sheet | Excel Discussion (Misc queries) | |||
| Populate sheet with lines from other sheet | Excel Discussion (Misc queries) | |||
| Is it possible to have more than 65,336 lines in one sheet? | Excel Discussion (Misc queries) | |||
| How do I set up a way to add up the number of lines used when cal. | Excel Discussion (Misc queries) | |||
Linear Mode
