Ok i tried it, but it prints out all the pages in the worksheet. i only want
to print out the active 'PAGE'. I would also like the codes to specify pages
and number of copies to print out.
--
help a friend help you


"Chip Pearson" wrote:

Try

ActiveSheet.PrintOut



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ernie" wrote in message
...
I need to create a macro to print the active page. Can anyone
help me with
the codes Please?
--
thanks in advance