Macro to Print Columns One By One

[skwiskwis]

Hello, I have been using excel for some years now to keep track of student grades. I have a "pinned" first column which contains the class requirements and then individual columns for each student. I can print the entire worksheet or the individual columns to give to students to show their progress.

My question is this: is it possible to create a macro so that I can print each student column one by one?

Currently, I have to highlight the column, go to "print area" and then "set print area" and then click on "print." I tried to enter these commands in a macro, but it would only print the same column over and over.

Thanks for the help

[VBA Noob]

Maybe something like

Please Login or Register  to view this content.

VBA Noob