PC Review


Reply
Thread Tools Rate Thread

Add info to last row of table?

 
 
=?Utf-8?B?UGF0cmljayBS?=
Guest
Posts: n/a
 
      25th Nov 2006
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

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
pull data from one table and combine with info from another table kvillan Microsoft Access Queries 1 8th Jan 2009 01:33 AM
Create new table based on existing table info Da Viking Microsoft Access VBA Modules 1 22nd May 2008 06:23 PM
Converting a table with rows of info into a table with columns Ernie Microsoft Access Database Table Design 8 15th Jun 2004 01:59 AM
sending info in a table to another table in a seperate database =?Utf-8?B?V0NCQQ==?= Microsoft Access External Data 0 8th Jan 2004 03:21 PM
Newbie needs help: how to fill in new table with any unchanged info from existing table Paul Simon Microsoft Access Queries 3 23rd Jul 2003 02:02 PM


Features
 

Advertising
 

Newsgroups
 


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