explained on 30/10/2012 :
When I select the print menu, it automatically prints all the pages that I
have in the worksheet. I am wanting to be able to select a range by using the
print dialogue box.

What version of Excel are you using that the *Print...* menu doesn't
open a dialog. (That's what the ellipses after the word *Print*
indicate)

Note that a menu is *NOT* an icon!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion