ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can you convert Excel pages into worksheets? (https://www.excelbanter.com/excel-worksheet-functions/211778-how-can-you-convert-excel-pages-into-worksheets.html)

ian_rrrr

How can you convert Excel pages into worksheets?
 
How can you convert multiple pages (from Page Break Preview) into multiple
worksheets?

Shane Devenshire[_2_]

How can you convert Excel pages into worksheets?
 
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

"ian_rrrr" wrote:

How can you convert multiple pages (from Page Break Preview) into multiple
worksheets?


Ron de Bruin

How can you convert Excel pages into worksheets?
 
Hi ian_rrrr

Maybe this code example will help
http://www.rondebruin.nl/hpagebreaks.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"ian_rrrr" wrote in message ...
How can you convert multiple pages (from Page Break Preview) into multiple
worksheets?



All times are GMT +1. The time now is 05:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com