Print

[Michael Vaughan]

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

 

[Frank stone]

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.