Thread
:
Trying something with Record Set
View Single Post
#
2
Posted to microsoft.public.excel.programming
Rick Rothstein \(MVP - VB\)
external usenet poster
Posts: 2,202
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
Reply With Quote
Rick Rothstein \(MVP - VB\)
View Public Profile
Find all posts by Rick Rothstein \(MVP - VB\)