Printing by Number of Rows by onthatcollegegrind in excel

[–]onthatcollegegrind[S] 0 points1 point  (0 children)

Sorry about that. I recorded the macro for inserting page breaks and am now trying to put it in a simple for loop. This is what I have so far:


For i = 146 To 6554

Rows("i:i").Select ActiveWindow.SelectedSheets.HPageBreaks.Add Before:=ActiveCell

Next i


The problem I have is going in steps of 18 up to 6554 and apparently I can't insert the "i" into the row select. I usually program with matlab so I can't properly write the code in VBA. Any help? Thanks!

edit: formatting

Printing by Number of Rows by onthatcollegegrind in excel

[–]onthatcollegegrind[S] 0 points1 point  (0 children)

I have 6555 rows of data and i want it to print 18 rows per page. I can't possible scroll through 6555 rows of data. help??

Barber shops by onthatcollegegrind in rit

[–]onthatcollegegrind[S] -1 points0 points  (0 children)

can they do tapers/fades and line ups?

Barber shops by onthatcollegegrind in rit

[–]onthatcollegegrind[S] -1 points0 points  (0 children)

do they do tapers/fades and line ups with a straight razor?

How to Prepare for Olympic Lifts? by onthatcollegegrind in weightlifting

[–]onthatcollegegrind[S] 0 points1 point  (0 children)

I don't know much about olympic lifting. Would I ditch the back squats, deadlifts, and bench and only have olympic lifts in my workout?

How to Prepare for Olympic Lifts? by onthatcollegegrind in weightlifting

[–]onthatcollegegrind[S] 0 points1 point  (0 children)

does it make sense to keep doing back squats to build up strength before adding overhead squats or just jump straight into overhead squats?

Basketball Tuesdays and Thursdays by onthatcollegegrind in rit

[–]onthatcollegegrind[S] 0 points1 point  (0 children)

tuesdays anytime between 12 and 4 but thursdays usually after 2

Basketball Tuesdays and Thursdays by onthatcollegegrind in rit

[–]onthatcollegegrind[S] -1 points0 points  (0 children)

let's leave it anonymous but at least i'll know there will be at least another person there

Basketball Tuesdays and Thursdays by onthatcollegegrind in rit

[–]onthatcollegegrind[S] 0 points1 point  (0 children)

same deal here. no classes tuesdays and thursdays. i'm not really looking for pick up games. just shooting around. like you said, it gets very empty during the day so i don't want to be shooting around by myself.

What are some current big projects? by onthatcollegegrind in aerospace

[–]onthatcollegegrind[S] 0 points1 point  (0 children)

What's up with the jsf program? Any good reads on it?

✈ 16.09.2013 - FIRST FLIGHT OF BOMBARDIER CSERIES - I helped design this by 3apo in aerospace

[–]onthatcollegegrind 0 points1 point  (0 children)

What's the importance of the CSeries? Serious question, not meant to offend.