Print
The VB book I have is very limited for excel. Is there a command in which I
can put for my input button that will print the page that I selected?? Thanks.. Michael |
Print
I'm not sure what you mean by "selected". did you select
it with the mouse? I think i tryed that and ran into problems. I think i it would be best to have the code select the print area but you gave no data structure so i don't know really. but here is some code i use to select and print. Range("A1").Select Selection.CurrentRegion.Select ActiveWorkbook.Names.Add Name:="PrintStuff", _ RefersTo:=Selection, Visible:=True ActiveSheet.PageSetup.PrintArea = "PrintStuff" 'ActiveWindow.SelectedSheets.PrintPreview 'ActiveWindow.SelectedSheets.PrintOut Copies:=2, Collate:=True the printpreview line and printout line are commented out here. use when ever one you want. -----Original Message----- The VB book I have is very limited for excel. Is there a command in which I can put for my input button that will print the page that I selected?? Thanks.. Michael . |
All times are GMT +1. The time now is 10:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com