Insert New Row on Sheet Not in Focus

  • Thread starter Thread starter Bull
  • Start date Start date
B

Bull

Is there a code that I can assign to a command button located in sheet
1 that inserts a new row in sheet 3-without activating sheet 3
(putting it in focus)??
 
Hi Bull:

worksheets("sheet 3").rows(insert row number here).insert
or
worksheets("sheet 3").range("C5").entirerow.insert
 

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

DREAM FEATURE: A macro that moves a row but asks me where to move it 18
Help Needed, May have bitten off more than I can chew 35
Copy / Insert n Rows of data simultaneously to 3 worksheets, same workbook 2
Insert rows in grouped sheets 2
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
range name define on non active(focused) sheet 10
Mid column sum formulas with varied ranges to sum 17
button names changed on copied sheet 4

Back
Top