Add info to last row of table?

P

Patrick R

I have a couple columns of information, and when you click the button it
copies the rows into a new row in a table. This is well and all, but if you
click the button again, it adds a new row to the table, but pastes the info
into that same row as before. I need it to paste it into the last row of the
table every time. This is the code I'm using right now. Thanks!

Sub AddCase()
'
' AddCase Macro
'

'
Sheets("Database").Select
Range("G7").Select
Selection.ListObject.ListRows.Add AlwaysInsert:=True
Range("G8").Select
Sheets("Add to Database").Select
Range("B8:H8").Select
Range("H8").Activate
Selection.Copy
Sheets("Database").Select
Range("A8").Select
ActiveSheet.Paste
End Sub
 

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

Top