Thread: Set print Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PC[_3_] PC[_3_] is offline
external usenet poster
 
Posts: 22
Default Set print Range

Hi,

I'm trying to set the print range of a report. The code I'm using is a
follows

Dim Print_Range As Range
Print_Range = Range("A1:E1", Selection.End(xlDown)).Select
ActiveSheet.PageSetup.PrintArea = Print_Range
End Sub

This isn't working though with a Run-time error 91, Object Variable or With
block variable not set.

Any ideas

Paul