| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print Range
I have made a macro to print a range in Excel. All it does is print a few
lines and dots at the top Range("D4:G11").Select ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,1,,,TRUE,,FALSE)" Is there another way of printing that range as a speadsheet or modifying the above macro to print the range in a viewable form. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Print Range
Try
Range("D4:G11").PrintOut Copies:=1 -- Jacob "Philosophaie" wrote: I have made a macro to print a range in Excel. All it does is print a few lines and dots at the top Range("D4:G11").Select ExecuteExcel4Macro "PRINT(1,,,1,,,,,,,,1,,,TRUE,,FALSE)" Is there another way of printing that range as a speadsheet or modifying the above macro to print the range in a viewable form. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| print range won't print | Excel Discussion (Misc queries) | |||
| Print Range | Excel Programming | |||
| Print Blank Pgs - Preview margins outside print range | Excel Discussion (Misc queries) | |||
| 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 | |||
Linear Mode
