Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to "Set Print Area" in Excel / VBA

Status
Not open for further replies.
wrbodine

wrbodine

Programmer
Aug 24, 2000
302
US
How can I, through VBA code, set the print area (File - Print Area - Set Print Area)?
 
Sort by date Sort by votes
Hi!

Code;
ActiveSheet.PageSetup.PrintArea = "$A$1:$B$6"

For the area A1:B6

Tip; use Register Macro, do the tings you want, finish registering, and then edit the Code. Excel is fantastic in that way;-)

Have fun, Roy-Vidar
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kapok1
  • Locked
  • Question
how to use vba to forbid "Worksheet Menu Bar" being selected
Replies
6
Views
230
kapok1
kapok1
remeng
  • Locked
  • Question
Run PowerShell Commands from Excel VBA
Replies
14
Views
1K
dhookom
dhookom
thanhthanh12
  • Locked
  • Question
Help vba
Replies
3
Views
319
combo
combo
xwb
  • Locked
  • Helpful tip
Performing VBA operations in other languages
Replies
1
Views
226
strongm
strongm
Andrzejek
  • Locked
  • Question
Outlook VBA - Trust access
Replies
3
Views
448
hermanlaksko
hermanlaksko

Part and Inventory Search

Sponsor

Back
Top