Selecting print range

  • Thread starter Thread starter Tamas Konczer
  • Start date Start date
T

Tamas Konczer

ActiveSheet.PageSetup.PrintArea = ActiveCell.CurrentRegion.Address

There is some empty row in the print range. In this case this formula
is not fine for me.

or

ActiveSheet.PageSetup.PrintArea = "R3C1:R15C2"

In this case I cannot use variable.

What is the solution for that issue?
 
Try this: is selecting range form activecell to last nonempty cell

ActiveSheet.PageSetup.PrintArea = Range(ActiveCell,
ActiveCell.SpecialCells(xlLastCell)).Address


"Tamas Konczer" skrev:
 
Thank you for your help!

excelent írta:
Try this: is selecting range form activecell to last nonempty cell

ActiveSheet.PageSetup.PrintArea = Range(ActiveCell,
ActiveCell.SpecialCells(xlLastCell)).Address


"Tamas Konczer" skrev:
Click to expand...
 
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

Beforeprint not executing 3
Need help creating a variable size printarea marco. 5
Set PrintArea Not Working 2
Cutting down code 3
Need Help in Selecting PrintArea Dynamically .. 0
Print Code Help 5
Avoiding an extra sheet when creating a pivot table 3
Not statements and blank page printing 2

Back
Top