| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying something with Record Set
Sheets(wsName).Range("A" & i) = rs1![NamedRange1] 'will not work
Try it this way (where I assume the name of your range is NamedRange1... Sheets(wsName).Range("A" & i).Value = Range("NamedRange1").Value Rick |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Open new record with selected fields from previous record | Excel Discussion (Misc queries) | |||
| Record macro doesn't record shape properties | Excel Programming | |||
| Finding last record in month for each of several types of record. | Excel Programming | |||
| Record Macro - Record custom user actions | Excel Programming | |||
| Need help autopopulating next new record with previous record data | Excel Programming | |||
Threaded Mode
