how do i use intelop to get page number?

[neodeaths]

hi i am currently using vs.net 2005 and intelop to connect to a ms excel to do some automation does anyone know how to get the page number from a range? what i am trying to do is to repeat the header for some rows and coloumn however since i have text from row 1-10 and some text below at around row 30-40 hence if my data gets too much and goes into page 2 the header is printed together with the "tail" of the rows at 30-40 e.g(header row together with row 35-40 is on page 2 instead) could anyone advice me how to overcome this problem? any help is appreciated

[Abhinav S]

This is not the best place for this question.

The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it. My latest tip/trick Visit the Hindi forum here.