Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Thanks Tushar for your response.
If I go to Names I will find "Ribbon" is sitting there very happy doing what I told it to do. Mainly waiting for the "Indirect" in the column B validation to do the redirection. Let us say "Ribbon" NAME represent Range (E1:E5) The specs for Ribbon. Now you are asking me to Name another Range this time a Table say Range (F1:G5) with the SAME name "Ribbon" From XL point of view both are ranges one column the other a table. Range(E1:E5) will contain {20cm,30cm,40cm etc) Range (F1:G5) will contain {20cm,10,30cm,20,40cm,40..etc) Will XL be confused ? I will go to the drawing board and "I will be back".... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
reinstate smart tag | Excel Discussion (Misc queries) | |||
make VLINKUP like vlookup; smart hyperlink by data value | Excel Worksheet Functions | |||
Invest smart | Excel Worksheet Functions | |||
Invest smart | Excel Discussion (Misc queries) | |||
Invest smart | Charts and Charting in Excel |