Thread: Print Range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Beep Beep Beep Beep is offline
external usenet poster
 
Posts: 101
Default Print Range

I am trying to print the following range called PrintData. The macro stops
at the command Range("PrintData").Select. I have this range defined in the
workbook.

Any advise???

Thanks
Frank

Sub PrintData()
Workbooks.Open Filename:= _
"C:\Documents and Settings\t_frankb\My Documents\Excel\Weekly Stability
Metrics\Weekly Stability Metrics Reports\06182007
\Charts\Weekly_Stability_Metrics_6500_6.6_6_18_07. xls"
Sheets("Weekly Arrival Data").Select
Range("PrintData").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
ActiveWindow.Close
'Call Print68005xChart
End Sub