Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

How to print first page of every Excel worksheet

If you have a lot of Worksheet and you would like to print all of it at the same, consider using VBA module code as follows
Sub PrintAllFirstPage() Dim sheet As Worksheet For Each sheet In Application.ActiveWorkbook.Worksheets sheet.PrintOut from:=1, To:=1 Next End Sub you can change the page range by editing the value of from:= and to:=



This post first appeared on HeaT SeekeR, please read the originial post: here

Share the post

How to print first page of every Excel worksheet

×

Subscribe to Heat Seeker

Get updates delivered right to your inbox!

Thank you for your subscription

×