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.