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" wrote in message
...
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

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 FileNew...on my computer.

Adjust that to your needs.


Gord Dibben MS Excel MVP


On Mon, 8 Sep 2008 06:46:02 -0700, Scott
wrote:

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