Selecting Only Certain Columns In Excel to Print 1

[nickjar2]

I hope someone can help on this (probably easy) problem.

Say for example I have a standard worksheet with the range A1 to G10 having data in.
When a user clicks a button (print) I don't want the whole page to print. What I need is this:
Column A and Column B should print on ONE page.
On page TWO, column A and col C should print.
On page THREE col A and D etc etc.

I know this is probably an easy problem but I just cannot seem to work out how to do it.

Cheers 4 any help,

Nick

 

[pjm]

hi nickjar2

File, Page Setup, Columns to repeat at left (on the "Sheet" Tab).
Then just insert page breaks before column C, D, etc.

pjm

 

[nickjar2]

Cheers pjm. That worked perfectly. Also, is this easy to do in code. The reason is that say the A column is dynamic or doesn't that matter.

Thanks again,

Nick

 

[pjm]

Hi Nick

I just recorded a macro and got the following code:

sub repeat_columns()
ActiveSheet.PageSetup.PrintTitleColumns = "$A:$A"
end sub

(So you could have "$A:$B" to print A and B on every page.)

Regards,
pjm

 

[nickjar2]

Brilliant.

Cheers pjm.