Finding the number of the page a particular cell lies in (excel)

[sanjay_sehdev]

For a worksheet broken into different pages by insertion of
pagebreaks is there some
function/VBA code ,by which info about the page number a particular
cell lies in can be extracted?

 

[Helmut Weber]

If you are talking about tables in Word,
as i've never heard about pagebreaks in Excel,
the application to which worksheets belong,

then

MsgBox selection.Information(wdActiveEndPageNumber)

returns the number of the page the end of the selection is on.

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"

 

[Helmut Weber]

Disregard,
the subject line was too long
for my newsreader.

 

[Cindy M.]

For a worksheet broken into different pages by insertion of

pagebreaks is there some
function/VBA code ,by which info about the page number a particular
cell lies in can be extracted?

This is something you need to ask the Excel specialists in the
excel.programming newsgroup. But you might starting here:

http://www.dicks-blog.com/archives/2004/12/22/page-of-pages-in-a-cell/

and here

http://j-walk.com/ss/excel/tips/tip65.htm

None of them give you the exact answer you're looking for, but they
hint at the approach (counting horizontal and vertical breaks).

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail