reports

  • Thread starter Thread starter j
  • Start date Start date
J

j

I need a report on how many pages and lines of information
are being used in a current workbook and be able to also
break that down into individual worksheets. Is there a
way to count the words, lines, and pages used?
 
I don't know who is asking you for this information, but while it might
make sense in a word processing document but is largely meaningless for
a spreadsheet.

For a worksheet how does one define a line of information?

Or for that matter what's a word in a spreadsheet? How does it relate
to a number? Or does it? Whats the numeric result of a formula? The
text result? The result of a database (or web) lookup? Words in a
chart? Axis labels?

What's a page? A printed page? A worksheet? A chartsheet? How about
a worksheet that given a particular margin setting for a particular
printer needs multiple pages to print?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top