Change value of Named Range in VB
Posted by Melanie Swarner on October 26, 2001 12:37 PM
How do I change the value of a named range in VB without selecting the cell? Because of future plans of the project, I need to use a named range and what it refers to could change each time program is run.
I have a list box with multiple selections. As I iterate through it, it changes the value of a cell if an item is selected. However, if I select the cell first, it erases all of my subsequent selections and I only get the results of the first selection.
It seems pretty simple. There's got to be a way to do it, I just don't know it.