Firstly, ive done a bit of googling, and found a few articles relating to my problem. None seem to help though.
I require a simple method of acquiring the "Page Number" of the selected cell.


Something like this, does not work. Even though i read that it does.
I do not have any Vertical Page Breaks. They are all horizontal.
The worksheet i will be viewing has about 30-40 pages.

Are there any simple ways of doing this.

NOTE: I DO NOT want a solution involving Print Preview.