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. |
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. |
All times are GMT +1. The time now is 01:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com