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
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 -> RecordOriginally Posted by mridzuan
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 .Just do what you said and record the macro: Tools -> Macro -> Record
Then step into it, copy and paste onto this forum
After searching the net, I've managed to get the codes that I required:
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 thisPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks