Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
print range won't print | Excel Discussion (Misc queries) | |||
Print Blank Pgs - Preview margins outside print range | Excel Discussion (Misc queries) | |||
Print Range - VBA | Excel Programming | |||
Can you get the range reference for each page in a worksheet print range? | Excel Programming | |||
Excel 2000 VBA - Set Print Range in dynamic range | Excel Programming |