My excel worksheet runs into several pages. The first few show some
information, and the next few pages are annexures to the initial pages.
I dont want to show page numbers in the first few pages, whereas i want to
show "Page x of y of annexure A" on the next few pages.
Further this pagination should be dynamic and i dont want to key in the page
numbers.
In this situation, i cant use page break preview as it would make page
number entry manual. Also i dont want header and footer as it would apply to
all the pages which i dont want.

HEnce please tell me how to show "PAge x of y" in one of the cells on the
worksheet. x should show the current page number and y should denote the
total pages in the worksheet.

Please help.

"Bill Sharpe" wrote in message
...
S N wrote:
you have not understood the problem correctly.
Actually i want to fill a cell in my worksheet which dynamically shows
the number of pages that would be printed when i print the worksheet on a
printer. this would be the same number as would be shown in print
preview. however i dont just want to see in print preview, but also want
to fill up a cell with this data.
the other data i want is the current page number filled up in a cell.
meaning "page x of y" where x is the current page number and y is the
total number of pages that would be printed in the worksheet.
please help


I understand what you want but I don't understand why you "need" to show
this information in a cell. Doesn't a header or footer give you the
information you need? A quick print preview will display the result.

Alternatively, Page Break preview view will show you the pages.
Control-End will take you to the last page.

Bill