Thank you Dave

Works Great

Greg
"Dave Peterson" wrote in message
...
Application.Dialogs(xlDialogPrint).Show

And if you had a userform, you could use:

worksheets("sheet1").printout copies:=clng(textbox1.value)



Greg B wrote:

I am not sure of what it is but I need the screen where you choose your
printer and print out amounts.

How do I get this to show in a macro?

Thanks in advance

Greg

--

Dave Peterson