Visual Basic Code

April 12th, 2003

I am making an Macro in excel. What is the code for an Page Break. Thanks

April 13th, 2003

got it (document).Selection.InsertBreak

April 13th, 2003

Ok I guess no one knows anything about VB. I suck but here is another question.

How do you make a document landscaped?

thanks

brunsodj · April 17th, 2003

Try this using a statement like this:

ActiveSheet.PageSetup.Orientation = xlLandscape

Dan

**dave holbon** · April 18th, 2003

I would just turn the paper sideways!

April 12th, 2003	Top \| #1
NLM Unregistered Posts: n/a	Visual Basic Code I am making an Macro in excel. What is the code for an Page Break. Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
help with visual basic 6	saithe	Web Design & Coding	1	December 28th, 2005 7:20am
Visual Basic 6 – Drawing Code Help	indyjones	Web Design & Coding	3	February 19th, 2005 11:46am
visual basic.net help	GhoulScout	Web Design & Coding	13	December 16th, 2004 2:12am
Visual Basic 6 Code Request	prinsipe	Windows Desktop Systems	3	August 18th, 2004 2:13pm
Visual Basic 6.0	rickang	Web Design & Coding	1	March 21st, 2002 2:22am

April 13th, 2003	Top \| #2
NLM Unregistered Posts: n/a	got it (document).Selection.InsertBreak

April 13th, 2003	Top \| #3
NLM Unregistered Posts: n/a	Ok I guess no one knows anything about VB. I suck but here is another question. How do you make a document landscaped? thanks

April 17th, 2003	Top \| #4
brunsodj OSNN Addict Joined: May 2002 Posts: 103 Reputation: 10 Power: 120	Try this using a statement like this: ActiveSheet.PageSetup.Orientation = xlLandscape Dan

April 18th, 2003	Top \| #5
dave holbon OSNN Veteran Addict Joined: May 2002 Location: London England Posts: 1,014 Reputation: 140 Power: 130	I would just turn the paper sideways!