I am printing from an excel sheet that is "hidden behind the scenes" in a vb app (the end user never sees teh excel sheet-I just want to capture it's print capabilities). How can I let the user select the number of copies. I wasa thinking of an input box where they enter the number of copies but I need to relay that value to Excel or the printer. "Printer.Copies" didn't generate an error but didn't generate the correct result either. Thanks!