Macro for adding data into the first row of a table

[anvike]

Hi guys,

I want to create a macro that adds data into a table. I would like the new data to be added to the first row of the table. This means that the previous inputs should be "pushed" one row down, making room for the new input.

Can anyone help?

 

[Osvaldo Palmeiro]

Hi. Here you go with a very basic code. It inserts a row and some words at row 2.

Sub InsertRow()
 Rows(2).Insert
 Range("A2").Resize(, 4).Value = "hello"
End Sub