Print specific pages

[girapas]

An Excel programming newbie needs macros:
1) to print only the pages of a sheet that meet given criteria.
2) to ask the user (before print of course) for a confirmation of the above
printing.
Thanks

 

[Frank Kabel]

Hi
have a look at the printout method in the VBA help
Also look at the msgbox method