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

Print Range
 

"Beep Beep" wrote in message
...
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

Hi

Try

PrintData.select

instead of

Range("PrintData").Select

Works for me

Best N10