Inserting pages in excel sheet

  • Thread starter Thread starter Ussiddiqui
  • Start date Start date
U

Ussiddiqui

hi , i am in a little prblem

I am dynamically adding rows in the work sheets ... i am adding rows 1
by 1 in the work sheet, but i want that when there are 53 rows complete
in the work sheet , insert a new page in the work sheet and then start
inserting rows in that... please help


Q : how to insert page in a perticular work sheet. so that i can add
new rows from there onward...
 
I think you are talking about inserting a page break. Look in Help for
PageBreak. HTH Otto
 
Ussiddiqui > said:
hi , i am in a little prblem

I am dynamically adding rows in the work sheets ... i am adding rows 1
by 1 in the work sheet, but i want that when there are 53 rows complete
in the work sheet , insert a new page in the work sheet and then start
inserting rows in that... please help


Q : how to insert page in a perticular work sheet. so that i can add
new rows from there onward...
Click to expand...

ThisWorkbook.Worksheets.Add
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert rows in grouped sheets 2
Mid column sum formulas with varied ranges to sum 17
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
DREAM FEATURE: A macro that moves a row but asks me where to move it 18
Insert Row also adds formulas and moves cursor 2
Changes in How Code Acts After Upgrade of Excel 2
Macro to Combine Data from Multiple Sheets with Cell References 4
Autohide rows based on formula in another sheet 0

Back
Top