Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying something with Record Set
Can Someone tell How I can reference these to a NamedRange or can't this be
done I Get the error # 3265 Item cannot be found in collection VENDOR_ID VEND_PART_NUM VEND_DESC Sheets(wsName).Range("A" & i) = rs1![NamedRange1] 'will not work 'Sheets(wsName).Range("A" & i) = rs1!VENDOR_ID 'Sheets(wsName).Range("B" & i) = rs1!VEND_PART_NUM 'Sheets(wsName).Range("C" & i) = rs1!VEND_DESC |
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 |