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.
 
Back
Top