ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Insert Row on Every Page (https://www.excelbanter.com/excel-discussion-misc-queries/13408-insert-row-every-page.html)

PaulFincannon

Insert Row on Every Page
 

Hi,

Is there a way to insert a row and have it automatically inserted on
each page that follows? I know how to have the repeat row at top, but
is there a way to insert a row for every 25 rows, for example?
Thanks!


--
PaulFincannon
------------------------------------------------------------------------
PaulFincannon's Profile: http://www.excelforum.com/member.php...o&userid=19978
View this thread: http://www.excelforum.com/showthread...hreadid=345904


Dave Peterson

This kind of thing becomes a lot easier if you take away the each page request.

If you were to ask how you can insert a row after rows 25, 75, 125, 175, etc,
then it's pretty straight forward.

But if you really want to base it on your pagebreaks, you could look for each
pagebreak, count down 25 and insert the new row.

But if the pagebreaks are automatic, then you could be changing them.

You wanna change your question??? <vbg

PaulFincannon wrote:

Hi,

Is there a way to insert a row and have it automatically inserted on
each page that follows? I know how to have the repeat row at top, but
is there a way to insert a row for every 25 rows, for example?
Thanks!

--
PaulFincannon
------------------------------------------------------------------------
PaulFincannon's Profile: http://www.excelforum.com/member.php...o&userid=19978
View this thread: http://www.excelforum.com/showthread...hreadid=345904


--

Dave Peterson


All times are GMT +1. The time now is 11:21 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com