ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Add info to last row of table? (https://www.excelbanter.com/excel-programming/378119-add-info-last-row-table.html)

Patrick R

Add info to last row of table?
 
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



All times are GMT +1. The time now is 07:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com