I have VBA that selects a row, but it is an entire row.
I need it to select only the row INSIDE a table. "Table1"Chris Helper Add Row.xlsm
Here is the line:
'this inserts row but I need insert row INSIDE table only
ActiveCell.Rows("1:" & Qty).EntireRow.Select
Here is the entire code:
Sub Insert()
Qty = Range("L2").Value
Range("A4").Select
Thank you very much
ActiveCell.Rows("1:" & Qty).EntireRow.Select
Selection.Insert Shift:=xlDown
ActiveCell.Select
Range("A4").Resize(Qty, 4).Value = Range("H2:K2").Value
End Sub
Bookmarks