Print Code

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have currently built a template where others can input invoicing data into
applicable cells and it gives them costing results out beside those cells. I
have made the template where they can enter 1,000 invoices if needed.

My question is...Is there a VBA code I can write or another way to create a
print option that will only print to the cells that have been populated and
not the entire 1,000 lines in the template?

Thanks
 
Hi Scott,

Stop spoon feeding them! It's not very hard to select which
pages to print in the dialog box, and while they're at it they
can also check that they aren't printing in color etc.

Be strong!!! They're not children!!! (supposedly)

HTH
Martin
 
Scott

Probably would be better to create a real Template for your Invoices.

Then each copy would be one invoice only and users would fill in, print and
save.

You should have an Invoice Template in File>New...>on my computer.

Adjust that to your needs.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help with SUMPRODUCT Formula 10
Export Data from another source to use in an excel template 0
Stray mark causing extra page to Print 5
auto numbering an exel work book sheet everytime it opens or print 1
Suppress @VALUE! on a template. 4
How to use Picture as template 2
set the numbers on the invoice template 1
Saving a copy without incrementing number 10

Back
Top