Print Range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Beep Beep said:
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
Click to expand...

Hi

Try

PrintData.select

instead of

Range("PrintData").Select

Works for me

Best N10
 
Back
Top