printing ranges ina macro

  • Thread starter Thread starter cindy
  • Start date Start date
C

cindy

Hi-
Hopefully someone can help me with this. I have a user,
who has a workbook, with 5 worksheets - each of them
having a range of data that needs to be printed.
Can I create a macro that will print (in one command)
each of those ranges on a separate page?
I've looked for some ideas on this, but have not been
successful - any help is appreciated!!!

thanks
 
Hi
one way:
- start recording a macro
- set the print areas
- print each sheets separately
- stop recording

Now use this macro
 
You must log in or register to reply here.

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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Macro to print specified range of several work sheets 2
VBA set thick borders around non empty cells in range 0
Userform to Select what worksheets to print 1
Excel VBA - Problem with Closing Print Preview 0
Print Ranges 7
need a macro to set the print range only for visible rows 1
Macro for all Excel Workbooks to print to PDF 2

Back
Top