| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Database Record add
I have the following macro that adds a record to the database "TimeRecords"
Application.Goto Reference:="Export_Data" Selection.Copy Application.Goto Reference:="PT_Data" 'first row of database Selection.End(xlDown).Select ActiveCell.Offset(rowOffset:=1, columnOffset:=0).Activate Selection.PasteSpecial Paste:=xlValues My problem is the database range does not expand to add this record I do not want to use the user database form to add this record oldjay |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Database Record add
See the reply to your earlier post today.
-- Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "Oldjay" wrote in message I have the following macro that adds a record to the database "TimeRecords" Application.Goto Reference:="Export_Data" Selection.Copy Application.Goto Reference:="PT_Data" 'first row of database Selection.End(xlDown).Select ActiveCell.Offset(rowOffset:=1, columnOffset:=0).Activate Selection.PasteSpecial Paste:=xlValues My problem is the database range does not expand to add this record I do not want to use the user database form to add this record oldjay |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I email just one record from an excel database. | Excel Discussion (Misc queries) | |||
| Printing a database record | Excel Discussion (Misc queries) | |||
| Links to External Database | Excel Discussion (Misc queries) | |||
| Function that filters a list (Database) for criteria in a range a. | Excel Worksheet Functions | |||
| How do I save a record from an excel template to a database in a . | Excel Discussion (Misc queries) | |||
Linear Mode
