I've *******ized the following from a recorded macro but it won't wor
with the variable name 'davvsheet', but it works fine if I specif
workbooks(".....") etc.?

With OSSheet
.Columns("L:L").Select

DAbook.Names.Add Name:="Lookuplist2", RefersToR1C1:= _
"=davvsheet!c1"

Any help would, as always, be much appreciated.

Regards,

Adria

--
Kobayash
-----------------------------------------------------------------------
Kobayashi's Profile: http://www.excelforum.com/member.php...info&userid=87
View this thread: http://www.excelforum.com/showthread.php?threadid=27358