<div>
Hi,<br />
<br />
How do you determine the names of the new files?<br />
<br />
Regards
</div>


Hi,

How do you determine the names of the new files?

Regards

<div>
Hi rgonzo, <br />
<br />
thank you very much for your quick feedback. <br />
<br />
for example the cell value/contents in Column B &nbsp;directly below the page breaks. <br />
<br />
Thank you <br />
<br />
Regards, Andreas
</div>


Hi rgonzo,

thank you very much for your quick feedback.

for example the cell value/contents in Column B  directly below the page breaks.

Thank you

Regards, Andreas

<div>
Hi rgonzo, <br />
<br />
thank you very much for your great support. Initial testing showed that it worked partly well. <br />
<br />
I will do some more thorough testing and then let you knwo. <br />
<br />
again, thank you very much for your professional help. I really appreciate it. <br />
<br />
Regards, Andreas
</div>


Hi rgonzo,

thank you very much for your great support. Initial testing showed that it worked partly well.

I will do some more thorough testing and then let you knwo.

again, thank you very much for your professional help. I really appreciate it.

Regards, Andreas

<div>
Hi rgonzo, <br />
<br />
thank you very much for your great and professional support. I tweaked the code a tiny bit and added 'On Error Resume Next' and it worked just fine. <br />
<br />
Great job rgonzo, thank you very much. <br />
<br />
Regards, Andreas
</div>


Hi rgonzo,

thank you very much for your great and professional support. I tweaked the code a tiny bit and added 'On Error Resume Next' and it worked just fine.

Great job rgonzo, thank you very much.

Regards, Andreas

<div>
<div class="content wysiwyg-content">
Dear Experts: <br />
<br />
I got a huge file where I have more than 300 manually inserted page breaks. <br />
<br />
Is it possible by means of VBA code to split this file into multiple/individual files (more than 300) based on these page breaks. <br />
<br />
Help is more than appreciated. Thank you very much in advance. <br />
<br />
Regards, Andreas
</div>
</div>


Dear Experts: 

I got a huge file where I have more than 300 manually inserted page breaks. 

Is it possible by means of VBA code to split this file into multiple/individual files (more than 300) based on these page breaks. 

Help is more than appreciated. Thank you very much in advance. 

Regards, Andreas

split excel file into multiple files based on page breaks

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.