Macro that will print each column starting with column B on a seperate page

I posted this in the general forum before seeing that this forum exists.

I have a spreadsheet that contains a header column in column A. I need a macro that will print each column starting with column B on a seperate page until it reaches a column with no data and then stop.

I have compiled the script below from doing various searches, but it is not stoping when there ceases to be column data. Can someone help in tweaking this to work?

Thanks so much!

Please Login or Register  to view this content.