How do I add a new row?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I want to create a button when I click on it a new row will apper.

In need the code in VBS.

Thanks for all the helpers.
 
With a cell in Col A selected this will insert a new row above the selected
cell.

Sub insertrow()
ActiveCell.Insert Shift:=xlDown
End Sub
 
Record a macro in Excel and see the code.
Amend for your VBScript environment.

NickHK
 
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

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
update a new row everytime I click a button 1
how to add new row to table in Excel 2003? 3
inserting data in next row on clicking a button 2
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
Eliminate blank row at top of Text Box entries 3
Find next problem 1
DREAM FEATURE: A macro that moves a row but asks me where to move it 18

Back
Top