insert row vba
Range("b4").EntireRow.Insertvba add row to table
' If you want to add a row to a table named "Sales_Table" in the active sheet
' and write values in it do as follows:
' Declare and set worksheet
Dim ws As Worksheet
Set ws = ActiveSheet
' Declare an object to contain the table and set it on "Sales_Table
Dim tbl As ListObject
Set tbl =ws.ListObjects("Sales_Table")
' Create a new row for the table, after declaring a variable named "newrow"
Dim newrow As ListRow
Set newrow = tbl.ListRows.Add
' Let's write some values in the cells at the 1st, 2nd and 3rd column
' of the specified row
With newrow
.Range(1) = 83473
.Range(2) = "HJU -64448"
.Range(3) = 5
End WithCopyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
