Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having a problem using a variable to add a 'name'
Julie, thanks, but that hasn't worked I'm afraid? I think I'm losing the wood for the trees! Basically, I just want to define a range (column A in sheet 2) in cod and then use these values for the validation list in sheet 1. followed a link to the Contextures site, which was very good, as initially I had the values in different workbooks. This worked but a soon as I closed the workbook with the validation values in th workbook with the validation applied lost all the list items. So, I' opening the validation book, copying the list items from the other boo to a new sheet, hiding/protecting this sheet and then, and this is wher I'm stuck, trying to apply validation to a column on one of the sheets using the value in the, now hidden, sheet? Hopefully this makes sense? 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 to add a 'name'
In book1 I had a sheet named davvsheet. It was protected and hidden
In Book2 i ran this code Sub BBTest() Dim DAbook as Workbook Set DAbook = Workbooks("Book1.xls") DAbook.Names.Add Name:="Lookuplist2", RefersToR1C1:= _ "=davvsheet!c1" End Sub It created the name LookupList2 in Book1 adn the name refered to column A of sheet davvsheet. -- Regards, Tom Ogilvy "Kobayashi" wrote in message ... Julie, thanks, but that hasn't worked I'm afraid? I think I'm losing the wood for the trees! Basically, I just want to define a range (column A in sheet 2) in code and then use these values for the validation list in sheet 1. I followed a link to the Contextures site, which was very good, as, initially I had the values in different workbooks. This worked but as soon as I closed the workbook with the validation values in the workbook with the validation applied lost all the list items. So, I'm opening the validation book, copying the list items from the other book to a new sheet, hiding/protecting this sheet and then, and this is where I'm stuck, trying to apply validation to a column on one of the sheets, using the value in the, now hidden, sheet? Hopefully this makes sense? 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 | |||
Having a problem using a variable in | Excel Programming | |||
Variable problem | Excel Programming | |||
Object variable problem | Excel Programming | |||
vba variable problem | Excel Programming | |||
Problem trying to us a range variable as an array variable | Excel Programming |