excel for mac print row at each page break

Go down 1 cell, alas, isnt recorded as such, but as Range(A2).select. Please let me know if things dont work out.

If you are new to the CNET Forums, please read our CNET Forums FAQ.

Once reported, our moderators will be notified and the post will be reviewed.

The macro in VBA: Sub Macro1() For i 1 To 400 ActiveCell.Offset(1).Select ActiveWindow.SelectedSheets.HPageBreaks.Add Before:ActiveCell Next i End Sub Thats about the whole story.

Introduction to writing and using macros: It takes some learning, but youll get a rich reward.

Am I right If not then correct me, or better still rephrase your question, and give examples like you want to print the same heading in all pages and only row 3 would be printed in page 3, only row 4 in page 4, and so on, until you have 400 pages printed.

So a row per store.

I currently print the report and give it to someone.

But this time they want me to print each store out on its own page and send that to the store.

So the heading in row one then the row of data in row 2, then the same but with row 3 on the next page.

I havent tried what he wrote, but what Im posting here has been tested and has worked.

Kees macro will generate an error, and I dont think it will work just the way you wanted it to be.

I tried other simpler methods which I expected to work but failed, but the macro below has worked for me.

I know there are other methods to accomplish this but why bother when this one works.

My only concern is that it may use much of your memory because of the big size of the array.

It activates Sheet1, and stores the heading in row 1 in tmpRow1.

Then it goes to row 2 and stores its value in tmpMoreRows, which is an array and can store up to 400 entries.

Later if you wish to add more rows you have to increase the size of your array: Ex.

Dim tmpMoreRows(1000) As Variant and also increase the greater number in your For Next loops: Ex: For i 1 to 1000 Next 2.

Then it activates Sheet 2 and pastes the heading in row 1, skips one row, and pastes the contents of row 2 in Sheet1 into row 3 of Sheet 2.

Then it does the same for the other rows.

Then it prints out what it wrote in Sheet 2 for all the pages.

After printing all the pages it deletes what it wrote in Sheet 2.

That is to say, I started with a heading row 1 and cell A2 selected.

When it was run, it was way down near 401 and all above were page-breaks.

Please let me know if things dont work out.

Excel For Mac Print Row At Each Page Break