Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having a problem using a variable in
Hi
by placing "davvsheet" in the quotes you've made it a literal string try RefersToR1C1:= "=" & davvsheet & "!c1" Cheers JulieD "Kobayashi" wrote in message ... I've *******ized the following from a recorded macro but it won't work with the variable name 'davvsheet', but it works fine if I specify 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, Adrian -- Kobayashi ------------------------------------------------------------------------ Kobayashi's Profile: http://www.excelforum.com/member.php...nfo&userid=871 View this thread: http://www.excelforum.com/showthread...hreadid=273587 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable problem | Excel Programming | |||
SaveAS w/ a variable name problem | Excel Programming | |||
vba variable problem | Excel Programming | |||
Mixed variable problem | Excel Programming | |||
Problem trying to us a range variable as an array variable | Excel Programming |