Reply to thread

Message: [QUOTE="Dave Peterson, post: 6420947"] I would still use variables to represent the objects I wanted to use. dim myListRng as range dim DBWB as workbook const cstrdatabasewb as string = "whatever" set dbwb = workbooks.open(cstrdatabasewb) with dbwb.worksheets("Lists") set mylistrng = .range("C2:C211") end with me.worksheets("queryemp").lstemployee.listfillrange _ = mylistrng.address(external:=true) I'd probably want to close that workbook, so I'd use: me.worksheets("queryemp").lstemployee.list = mylistrng.value dbwb.close savechanges:=false I don't understand the second problem. [/QUOTE]