Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to page total?

0 views
Skip to first unread message

David

unread,
Oct 14, 2002, 6:31:28 AM10/14/02
to
Hi;
How to page total?
Best Regards


Brian Small

unread,
Oct 14, 2002, 4:39:34 PM10/14/02
to
David,

If you are trying to determine the number of pages, then you can use the
following VBA statement to determine the number of pages in the active
worksheet.

Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")

Alternatively, you can create a named range called NumberOfPages for
example, and set the Refers To field to

=GET.DOCUMENT(50)

Then, you can retrieve the number of pages using the following command:

=NumberOfPages

Regards,
Brian Small
________________________________
"David" <ad...@sogutsenseramik.com.tr> wrote in message
news:OEe1Ly2cCHA.2324@tkmsftngp08...

0 new messages