Code:
selection.Printout

Manual:
or under the file menu, set the printarea

or when you go to print, choose selection in the dialog

--
Regards,
Tom Ogilvy


" wrote:

I am trying to creat a macro to print only a selection of a spreadsheet that
has data, however, everytime I create it all goes well. Then I run it and it
prints the entire spreadsheet (4 pages). Can anyone help me? Thanks