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