Command button to print highlighted cells.....

I would like to create a VBA button in an Excel spreadsheet (Office 2002) which when pressed, would print each cell the user has highlighted ,separately on different pages. Meaning the content of each cell on its own page. Where do I start with this one?

You can assign this procedure to the click event of the command button:

Please Login or Register  to view this content.

The DisplayAlerts is needed to avoid Excel error of selecting only one cell for the page setup.

HTH

Jason