How can you convert multiple pages (from Page Break Preview) into multiple worksheets?
I ian_rrrr Nov 26, 2008 #1 How can you convert multiple pages (from Page Break Preview) into multiple worksheets?
S Shane Devenshire Nov 26, 2008 #2 Hi, there is no automatic way to do this in any version of Excel. You might write VBA code to do it or you can cut and paste each page manually. Maybe someone has created an add in to do this but I am not aware of it. If this is helpful, please click the Yes button. Cheers, Shane Devenshire
Hi, there is no automatic way to do this in any version of Excel. You might write VBA code to do it or you can cut and paste each page manually. Maybe someone has created an add in to do this but I am not aware of it. If this is helpful, please click the Yes button. Cheers, Shane Devenshire
R Ron de Bruin Nov 26, 2008 #3 Hi ian_rrrr Maybe this code example will help http://www.rondebruin.nl/hpagebreaks.htm
