Setting print area

[mridzuan]

Hi everybody,

Could anyone help me with a vb where I can define:
1. the print area from A1:F25
2. rows to repeat at the top 3:5
3. Columns to repeat at left A:A
4. Orientation = Landscape
5. Scaling = Fit to 1 page wide 2 page tall

[mattsgr1]

Hi everybody,

Could anyone help me with a vb where I can define:
1. the print area from A1:F25
2. rows to repeat at the top 3:5
3. Columns to repeat at left A:A
4. Orientation = Landscape
5. Scaling = Fit to 1 page wide 2 page tall

Just do what you said and record the macro: Tools -> Macro -> Record

Then step into it, copy and paste onto this forum

[mridzuan]

Just do what you said and record the macro: Tools -> Macro -> Record

Then step into it, copy and paste onto this forum

That is the problem. I'm not really a programmer and I'm hoping that somebody would help me with the codes or at least point me to where I can get the codes .

[mridzuan]

After searching the net, I've managed to get the codes that I required:

Please Login or Register  to view this content.

However, I couldn't get the codes for "rows to repeat at the top" and "Columns to repeat at left". Would be glad if somebody could help me with this