Finding page breaks in excel sheets & inserting empty row

Hi all,

I am trying to find a way to identify which page a cell is on (after a print preview is performed) and then insert rows to the worksheet based on what values are found before and after the page break:

if values on page1 <> values on page2 then just add header:

1
1
1
1
----page break----
2
2
2
3
3

becomes:

1
1
1
1
----page break----
<insert row>
2
2
2
3
3

and if values page1 = values page2 then insert rows until they don't

1
1
1
1
2
2
-------page break-----
2
2
3
3
3

becomes

1
1
1
1
<insert row>
<insert row>
----page break----
<insert row>
2
2
2
2
3
3
3


The code I have so far is:

Please Login or Register  to view this content.

where the two lines with the #getPageNumber()# variable standin is where I don't know the command for getting the page number.

Is there an easy way to get this?

Hello Ouka,

This is not such a simple task. You have do the caluclations yourself. Here is link to site that has a VBA macro to do this.

Page Numbers In VBA

Hello Ouka,

I have not run that code before. Sorry you're having problems with it. If you get stuck, let me know.