Thread: Selecting print range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tamas Konczer Tamas Konczer is offline
external usenet poster
  
Posts: 4
Default Selecting print range
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?

Reply With QuoteReply With Quote