JimChampaigne
New Member
- Joined
- Dec 30, 2011
- Messages
- 4
I am new to VBA.
I have my grade sheet in excel: assignments across the top in columns A - Z, and student names and grades in rows from row 6 to row 106.
I would like to be able to select a range of rows (one of four class sections) and print one row for each student name on a individual page (landscape).
Last year I would set rows 1-5 as titles, and then manually select row 6, Print...
With 100 students, this gets a little boring.
How can I use VBA to set the print range to increment through a range of rows one at a time?
ActiveSheet.PageSetup.PrintArea = ? ? ? ?
ActiveSheet.PrintOut
I have my grade sheet in excel: assignments across the top in columns A - Z, and student names and grades in rows from row 6 to row 106.
I would like to be able to select a range of rows (one of four class sections) and print one row for each student name on a individual page (landscape).
Last year I would set rows 1-5 as titles, and then manually select row 6, Print...
With 100 students, this gets a little boring.
How can I use VBA to set the print range to increment through a range of rows one at a time?
ActiveSheet.PageSetup.PrintArea = ? ? ? ?
ActiveSheet.PrintOut