David.

???and you TRIED this?
since you cannot set the Printer Tray within Excel.
the recorder will record nothing.

...imo a useless answer.


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


David C. wrote :

do it manually while recording a new macro

then take a look in the code generated

then you see wich argument is used for changing the tray name (if
possible)