i want to know how many pages will print when i give print command on a particular worksheet
(and not how many worksheets are there in a particular workbook)

actually i want to display the following text on a particular column cell

page x of y (where x is the particular page on which the cell lies and y is the total number of pages that would print)

i dont want to use header and footer which give this detail because header and footer would give this detail in the header /footer area only, whereas i need to show this data in the cells in the page

please help