| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rs.addnew - named range vs. individual cell
Hi Everyone,
I know I can write the codes as follows to transfer data from Excel to Access... ..AddNew !FirstName = strFirst !LastName = strLast .Update but is there anyway to specify and entire named range and have that append into the access table without specifying each individual field? I've made my excel record include all fields the same as the access record. ~Jessica |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| value of one cell in a named range | Excel Programming | |||
| Referencing a named range based upon Range name entry in cell | Excel Worksheet Functions | |||
| Individual cell selection in a range | Excel Discussion (Misc queries) | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| If any cell in named range = 8 then shade named range | Excel Programming | |||
Threaded Mode
