LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Break a table into discrete info RJB Excel Discussion (Misc queries) 2 June 14th 08 04:18 AM
Use info in separate table file MnO Excel Discussion (Misc queries) 2 February 2nd 06 09:13 AM
Ref Transfering Info from a table Colin McLure Excel Discussion (Misc queries) 0 December 21st 04 11:09 PM
Formula to lookup info in a table James Excel Programming 5 March 5th 04 03:56 PM
Extract pivot table info jaya Excel Programming 2 October 16th 03 07:13 PM


All times are GMT +1. The time now is 11:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"