Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Break a table into discrete info | Excel Discussion (Misc queries) | |||
Use info in separate table file | Excel Discussion (Misc queries) | |||
Ref Transfering Info from a table | Excel Discussion (Misc queries) | |||
Formula to lookup info in a table | Excel Programming | |||
Extract pivot table info | Excel Programming |