how to know the number of lines on the sheet?

  • Thread starter Thread starter dizzy
  • Start date Start date
D

dizzy

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cells with varying number of lines 1
Save data from Notebook: copying to the USB stick using Linux and the command line 0
Rows with cells of varying number of lines 5
The Basics 4
How do you chart data from multiple sheets within a workbook? 3
Print entire workbook with each sheet starting at page 1 8
If named sheet exists then delete it 9
Export Sheet Values to new workbook 20

Back
Top