Macro to set multiple print area based on cell values

[acarter21]

Hi All,

Please see attached. We receive purchase orders via email. It comes in 1 file with multiple purchase orders on the 1 "page/file".

Each order has a cell that states "*** START OF PURCHASE ORDER - xxxxxxx***" and ends with " *** END OF PURCHASE ORDER - xxxxxx ***

I was hoping I could set up a macro that would start the print area at the start of the purchase order and end it at the end of the purchase order for each order on the page.

I.e. if there were 20 purchase orders, it would set up a print area for 20 pages with each order on its own page. We could then print these orders rather than manually setting the print area for each.

Thanks in advance for your help.

[dangelor]

Possibly this may work for you...

Please Login or Register  to view this content.