By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,969 Members | 2,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,969 IT Pros & Developers. It's quick & easy.

Named Ranges Find and Update

P: 5
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.Office.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
Jul 11 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.