Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
Macro Question with printing in MS Excel?
I'm admittedly not the best with writing macros. I've got a macro written that when you push a button, the set print area will print. What I'm trying to do is to specify where it prints to. I'd like it to print to PDF every time the button is clicked. But it seems like whatever the last selected printer is, it will print there.
Does anyone know how to specify a printer to print to within an excel macro?
Jim T: It looks like your answer was cutoff. After so many characters in a continuous string, Y!A cuts them off.
1 Answer
- Anonymous1 decade agoFavorite Answer
Application.Dialogs(xlDialogPrinterSetup).Show