Thread: Having a problem using a variable in
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kobayashi[_48_] Kobayashi[_48_] is offline
external usenet poster
  
Posts: 1
Default Having a problem using a variable in

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

Reply With QuoteReply With Quote