1) I have a Namedrange which is named Company in sheet 2.
Sheet 1 cell A2 has a list created via data validation referencing to this sheet 2 Column A values.
2) If i go to Name Manager (by doing a Ctrl+f3) on the name manager window the formula will be =Sheet2!$A$2:$A $6
3) I am using Microsoft.Offic e.Interop.Excel component.
4) Now on my .net application i want to find a namerange in sheet 1 with a particular name like "Company".
5) Currently in my excel file there are 5 companies. After update let's say there are 7 companies
6) I am adding more values to "Company" named range via the application and i want to update the reference to this named range in sheet 1 A2 cell so that it can reflect the changes of the added 2 extra companies names so that the formula will be =Sheet2!$A$2:$A $8
How do i find a name range and update the same?
By any chance can i delete a named range and then add/update
I Appreciate your help on this.
Thanks,
Roger
Sheet 1 cell A2 has a list created via data validation referencing to this sheet 2 Column A values.
2) If i go to Name Manager (by doing a Ctrl+f3) on the name manager window the formula will be =Sheet2!$A$2:$A $6
3) I am using Microsoft.Offic e.Interop.Excel component.
4) Now on my .net application i want to find a namerange in sheet 1 with a particular name like "Company".
5) Currently in my excel file there are 5 companies. After update let's say there are 7 companies
6) I am adding more values to "Company" named range via the application and i want to update the reference to this named range in sheet 1 A2 cell so that it can reflect the changes of the added 2 extra companies names so that the formula will be =Sheet2!$A$2:$A $8
How do i find a name range and update the same?
By any chance can i delete a named range and then add/update
I Appreciate your help on this.
Thanks,
Roger