Print Macro Help - Is it possible to Macro so only the pages in a sheet that have data in certain cells are printed?

B

Barryoffshore

Board Regular
Joined
Feb 21, 2005
Messages
73
I have a workbook that has 87 sheets, and each sheet has 21 printable pages. Is there a macro which will print only the pages that have entries on them? For instance, if on a single sheet, there is data in cells E7, E37, E66 & E95, only the pages that have those cells in them will print. Is a macro like this possible and if so, can someone help me with it please???

Thank you!!!
Bear
 
Sort by date Sort by votes
Thank you CharlesH... I must say - YOU, SHG, Michael M, Mikerickson and all the truly expert people on this board absolutely amaze me!!!
 
Upvote 0

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.
shg didn't contribute much to this thread -- I think Michael is today's star.
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
VBA for setting up the printing pages per sheet
Replies
0
Views
422
Aurum1
A
S
  • Solved
Button to print to PDF with custom file name & custom location
Replies
3
Views
538
mumps
mumps
B
  • Solved
macro to print selection when there is data in rows
2 3
Replies
24
Views
2K
bh24524
B
V
  • Question Question
Print to PDF in VBA
Replies
0
Views
510
visheshkotha
V
E
  • Solved
Macro to print a table filling from a sheet then move to the next row on the sheet
Replies
3
Views
161
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,249
Messages
6,171,031
Members
452,374
Latest member
keccles

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top