Print all data validation list

hi expert..

i have macro code to print all data/cell with data validation list, but not working
here is

Please Login or Register  to view this content.

i hope, you are there, could help me, how make code it's work..

thanks in advance...

john m

please, see my attach file...

sorry, i am missing..

Hi John,
maybe so

Please Login or Register  to view this content.

thanks, Nilem

It's work 100%....

but how do if selected cell, i means, print from cell 7-10 or 20-23..

It's possible??

not very clear, but maybe

Please Login or Register  to view this content.

nilem, i have testing your 2nd macro (post #6), but it,s not fully work...

Would like to be able, to print with 2 models :
1) code attached to a "Print All" button.
2) code attached to a "Print Page" button e.g. print page 7 or print page 10 to 20

thanks...