Programming a button to add a row

J

JeffK

I have a spreadsheet that will require the user to enter data in the cells
(B6:J6). I would like to add a button that will add another line below row
6, containing the same formatting. I would like the sheet to have the
ability to add up to 5 additional lines (Row 11).

Thanks
Jeff
 
J

JeffK

I'm actually going to try and use a user form to accomplish my task, no need
to reply.

Thank you
 

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

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Copy to a mid column range Row 10 - Row 20 4
Excel Add ^ to a row of cells containing letters 3
Add to a "number as text" 10
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Add a row with data 2
DREAM FEATURE: A macro that moves a row but asks me where to move it 18
adding row 2

Top