Forum Discussion

george christodoulou's avatar
george christodoulou
Copper Contributor
Sep 21, 2017

Page Layout and Page Break

Hello,   I would like to ask if there is any method that i could make different pages in the same sheet with the same layout. I would like to have an automatic system that could undersdant when i c...
excel
Scott Rogerson's avatar
Scott Rogerson
Copper Contributor
Sep 22, 2017

Can you attach a file, or explain this a bit more?  You could use VBA and press Alt-F11 to display the VB editor.

  1. Click the View menu within the Visual Basic Editor.
  2. Click Immediate Window from the View menu, or press Ctrl-G on your keyboard
  3. At this point the Immediate window will appear onscreen. This is a special area where any programming code you type will be executed immediately; hence the name.
  4. Type the following line of programming code into the Immediate window, exactly as written below, and then press Enter.

Do Until Sheets.Count=X: Activesheet.Copy,ActiveSheet: Loop

 

X=Number of sheets you desire.  As for the rest of your question, I am not sure until I understand better.

Resources