Inserting a Row with VBA - reply

  • Thread starter Thread starter Grond
  • Start date Start date
G

Grond

I hope, this is the proper way how to answer the question with reply
email "(e-mail address removed)". If not, I am sorry...

Try this:

Sub Insert_row()
ActiveCell.EntireRow.Insert Shift:=xlDown
End Sub

The code adds a new row above the row where is the active cell.

Bye

Grond
 
It looks like you started a new thread with your reply. This'll make it a
little harder (maybe impossible) for the original poster to see your response as
an answer to their question.

Since you used google to post, it looks like you didn't hit the reply
button--maybe you just started a new post????
 
Fortunately, I sorted the messages by subject, so the two threads were right
together. But you're right, replying to the thread is the best way.

--Tom
 
Back
Top