I used "Application.Dialogs(xlDialogPrint).Show" to show dialog, but can't
retrun the printset values which user setting. (like range_num, from, to,
copies, ...)

You can get back true or false depending on whether ok or cancel was clicked.
But you are out of luck on getting back any other info.

The printout method allows you to specify various settings before printing.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)


"james"
wrote in message
I used "Application.Dialogs(xlDialogPrint).Show" to show dialog, but can't
retrun the printset values which user setting. (like range_num, from, to,
copies, ...)