Hi,
Im a novice with excel but seem to be getting by just, ive come a little stuck and was wondering if anyone knows how to write a macro in excel that will print page 1 of each sheet in the workbook?
Many Thanks
Rob
Last edited by rob-bob; 01-14-2012 at 01:48 PM.
Sub PrintMacro() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.PrintOut From:=1, To:=1, Copies:=1 Next ws End Sub
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Thanks verymuch JBeaucaire this works great!!!!
Cheers
Rob
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Done Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks