Find the Page Number
 

Can anyone tell me how I can find the page number that a cell will
print on. I would like to build an index of products and their page
numbers within a price list workbook but I cannot find out how to read
the grey page numebr that you see in print preview mode.

I have only just started playing with VBA so be gentle !

Cheers

Graham

Find the Page Number
 

See this example Graham
http://www.dicks-blog.com/archives/2...ges-in-a-cell/

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Graham" wrote in message ...
Can anyone tell me how I can find the page number that a cell will
print on. I would like to build an index of products and their page
numbers within a price list workbook but I cannot find out how to read
the grey page numebr that you see in print preview mode.

I have only just started playing with VBA so be gentle !

Cheers

Graham