Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.programming
|
|||
|
|||
Database record add
You need to work an Autofit in there somewhere.
"Oldjay" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Database record add
See the reply to your post in the misc. group.
-- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "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 | |||
Database Record add | Excel Discussion (Misc queries) | |||
How do I email just one record from an excel database. | Excel Discussion (Misc queries) | |||
Find record in database | Excel Programming | |||
Printing a database record | Excel Discussion (Misc queries) | |||
how do I edit a record in database | Excel Programming |