Printing : HOw can select a particular printer in excel

  • Hello there. Its a simple question i suppose. Still i dont know the answer to it! :o :redface:
    Im running a macro to print a sheet in excel. I have everything set up(page breaks, etc) but i want to select my coloured printer as opposed to the B&W one when the macro is running. How can i get it to choose the printer? Cheers,


    victor.

    ___________________
    "Time is the best teacher; unfortunately it kills all of its students..."

  • oh sorry, my bad. didnt realise i was in the WORD forum and not Excel... sorry!

    ___________________
    "Time is the best teacher; unfortunately it kills all of its students..."

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!