I have a VSTO spreadsheet, and have re-jigged the front end. I need to change some named ranges to reflect this.
Couldn t see a good way of doing this, so I created other named ranges and pointed the code to refer to those instead.
Is there a better way?
I m not sure how being a VSTO spreadsheet would make any difference to how to update a named range. Assuming you want to extend the range of cells in a named range (and assuming Excel 2007) then go to Formulas tab and click "Name Manager" and select the name you want to update. At the bottom of the form click the "Refers to" button (the one with a red arrow pointing to the top left of a range). The form will collapse to just the Refers to box and you ll be able to re-select the range. Click the "Refers to" button again (now with a downward pointing arrow) to return to the full "Name Manager" form. Close the "Name Manager" and OK the prompt to save changes to the range.
Your range will now refer to the new selection. Hope that is what you wanted!
Excel.ActiveWorkbook.Names.Item(1).Delete();
Note: the brackets are not square, even though this is c#.
As a learning experience I recently tried implementing Quicksort with 3 way partitioning in C#. Apart from needing to add an extra range check on the left/right variables before the recursive call, ...
I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...
I have two EF entities. One has a property called HouseNumber. The other has two properties, one called StartHouseNumber and one called EndHouseNumber. I want to create a many to many association ...
I m using decimal type (.net), and I want to see if two numbers are equal. But I only want to be accurate to 10 decimal places. For example take these three numbers. I want them all to be equal. 0....
I m creating an STA version of the SynchronizationContext for use in Windows Workflow 4.0. I m wondering what to do about exceptions when Post-ing callbacks. The SynchronizationContext can be used ...
I ve got some code which sets up a datacontext. Often enough, the datacontext should be set to some underlying data collection, such as an ObservableCollection - but occasionally I d like to set it ...
I am building an application with C#. I managed to turn this into a single instance application by checking if the same process is already running. Process[] pname = Process.GetProcessesByName("...
NOTE I have asked the related question (with an accepted answer): How to combine DataTrigger and Trigger? I think I need to combine an EventTrigger and a DataTrigger to achieve what I m after: when ...