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

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

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



"Graham" <[email protected]> wrote in message news:[email protected]...
> 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
>