Print area

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hi,

I have a macro that every time copy the data from one
sheet to a new file. But whenever i wanted to print, I gt
some parts of the data not printed out for the new file.
How do i code in VBA to print all?

Many Thanks.

regards,
Tom
 
Range("A1").Select
ActiveSheet.PageSetup.PrintArea = ""
Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select
ActiveSheet.PageSetup.PrintArea = "$A$1:$I$14"
'>>>>>>>>>>>>>>your code<<<<<<<<<<<<<<<<

ActiveSheet.PageSetup.PrintArea = ""
N10
 
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 VBA - Problem with Closing Print Preview 0
PowerPoint Printing PPT to PDF without losing quality 1
Macro to control Print area/view 2
Excel print area which only prints pages of worksheet which are active 0
VBA to set dynamic print area 1
Setting print area 3
Epson XP-3150 not printing 2
Printing 3

Back
Top